Community
Select to view content in your preferred language

access relational datastore postgres database in arc catalog

1209
3
06-23-2021 01:27 AM
by Anonymous User
Not applicable
‎06-23-2021 01:27 AM

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.

0 Kudos
3 Replies
Scott_Tansley
by MVP Regular Contributor
MVP Regular Contributor
‎06-23-2021 01:31 AM

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

Scott Tansley
https://www.linkedin.com/in/scotttansley/
0 Kudos
VictorTey
by Esri Contributor
Esri Contributor
‎06-23-2021 06:05 AM

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.

cjms
by
Emerging Contributor
3 weeks ago

The steps below work for me with PgAdmin

  1. Remote into server with the Postgres Data Store
  2. Open command prompt
  3. CD your way into the C:\Program Files\ArcGIS\DataStore\tools folder
  4. Run "listmanageduser.bat"
  5. Write down the username, password, and database
  6. 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
  7. Open PgAdmin --> register new connection
  8. Enter username, password, and database from step 5
  9. Enter host name of the server with the datastore installed
  10. Port is likely 9876
    • Run 'netstat -ano' and search for the PID corresponding with the PID of postgres.exe in Task Manger
  11. Save connection

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

0 Kudos