topic Postgresql connection (ArcGIS10.1) using a non-default port in Data Management Questions

Postgresql connection (ArcGIS10.1) using a non-default port

DahaeHwang — Tue, 07 Aug 2012 12:22:42 GMT

Hi All,
I have more than one postgresql databases on a same server, and tried to specify the port in a host entry but had no luck.
How can I specify the port other than 5432? The DBMS server is Windows 2008 R2 and the client connecting to the server is Windows XP (32-bits). 'PGPORT' works..?

Thanks.

Re: Postgresql connection (ArcGIS10.1) using a non-default port

DahaeHwang — Mon, 13 Aug 2012 17:30:41 GMT

Just to provide what I got from tech support...

To connect to a specific port for postgresql database, the port number can be included after the instance name.
For example if Postgresql is listening to port # 5000, type in servername,5000 in the instance box.

Re: Postgresql connection (ArcGIS10.1) using a non-default port

KimPeter — Tue, 14 Aug 2012 21:04:56 GMT

Setting PGPORT on the client machine should also work if you are only ever connecting to one database cluster; otherwise, you have to switch that variable when you want to connect to the database cluster listening on a different port.

As an aside, the info about providing the port number in the Database Connection can be found in the Database connections topic:
http://resources.arcgis.com/en/help/main/10.1/#/Database_connections_in_ArcGIS_for_Desktop/019v00000003000000/