Community
Select to view content in your preferred language

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

823
2
08-07-2012 05:22 AM
DahaeHwang
by
Emerging Contributor
‎08-07-2012 05:22 AM
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.
0 Kudos
2 Replies
DahaeHwang
by
Emerging Contributor
‎08-13-2012 10:30 AM
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.
0 Kudos
KimPeter
by Esri Contributor
Esri Contributor
‎08-14-2012 02:04 PM
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/019v00000...
0 Kudos