Customers may wish to run two or more PostgreSQL servers e.g. version 8.4 and 9.0 on the same host. Using the existing PgOleDb driver it was not possible to specify the port, but there is a patched version which does allow you to do this by specifying the port in the Extended Properties part of the connection string. The PgOleDb driver has been included in the Astun 3rd Party Installer e.g.
In Data Share, if nothing is specified in Extended Properties, the default port 5432 is normally used. Once the PgOleDb driver has been installed you can now connect to your PostgreSQL database using a different port.
Configuring the Port number
The port can be set in iShare Studio by doing the following:
- Select the Data Share Connections node and click the Edit button
- Click on the Browse button for the DSN setting, highlighted red in the screenshot below:
- Select the All tab of the Data Link Properties screen.
- Select the Extended Properties entry and click Edit Value.
- Set the port via the Extended Properties e.g.
- Click OK, and OK again.
- Click Save to save your changes.