访问关系数据存储postgres数据库中rc catalog

689
2
06-23-2021 01:27 AM
by Anonymous User
Not applicable

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.

0Kudos
2回答
Scott_Tansley
Occasional Contributor III

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.

如果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.:slightly_smiling_face:

Scott

Scott Tansley
Consulting Architect (ArcGIS Enterprise)
https://www.linkedin.com/in/scotttansley/
0Kudos
VictorTey
Esri Contributor

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.

0Kudos