topic Re: access relational datastore postgres database in arc catalog in ArcGIS Enterprise Questions

access relational datastore postgres database in arc catalog

Anonymous User — Wed, 23 Jun 2021 08:27:42 GMT

Hi All,

is there any possibility to access the data in relational datastore through arccatalog ? if yes does it shows spatial data or only tables ?as per the documentation esri says it does have tables in postgres relational datastore.

kindly suggest on this.

Re: access relational datastore postgres database in arc catalog

Scott_Tansley — Wed, 23 Jun 2021 08:31:10 GMT

Hi,

The ArcGIS Data Store is only supposed to be accessible via the REST interfaces (via the Hosting Server) and certainly if you want to 'support'. The PostgreSQL database uses none-standard ports, and hidden credentials to dissuade you from doing so.

If you want to use the data in a desktop product (recommend Pro) then connect via the REST endpoint or extract the data as a copy (fGDB) and use it that way. 🙂

Scott

Re: access relational datastore postgres database in arc catalog

VictorTey — Wed, 23 Jun 2021 13:05:14 GMT

Accessing the postgres database directly is not recommended by Esri however if you are really determine to access the relational db, I don't see what can stop you :).

Have you tried updating pg_hba.conf(back this up first) to trust all host? that way you can log in without requiring a password.

Re: access relational datastore postgres database in arc catalog

cjms — Wed, 23 Apr 2025 18:41:29 GMT

The steps below work for me with PgAdmin

Remote into server with the Postgres Data Store
Open command prompt
CD your way into the C:\Program Files\ArcGIS\DataStore\tools folder
Run "listmanageduser.bat"
Write down the username, password, and database
Run "allowconnection.bat <ip of your computer> <username from step 5>"
- example: "C:\Program Files\ArcGIS\DataStore\tools>allowconnection.bat 12345 user"
- This will alter the pg_hba.conf file. You can open it to see your changes
- IP is the computer you are using, not the server that has the datastore
Open PgAdmin --> register new connection
Enter username, password, and database from step 5
Enter host name of the server with the datastore installed
Port is likely 9876
- Run 'netstat -ano' and search for the PID corresponding with the PID of postgres.exe in Task Manger
Save connection

Tables will be listed under the Schema --> username --> Tables