Esri documentation on how to connect to a PostgreSQL (non-gdb) database in Arc Pro v 2.7.0 in order to access the schema and perform queries only (rea

[LeslieCooper]

Hi friends, my mission is to connect to a PostgreSQL (non-geo) database in Arc Pro v 2.7.0 in order to access the schema and perform queries only (read only/no write permissions and I am not the DBA). I have been researching how to do this and am still unclear about the process. I would like to be able to present information clearly to the DBA (who is not in the GIS field) so they can perform any necessary requirements for the connection on their end but I'm unable to find a clear outline of it. I am currently trying to piece together the process using troubleshooting questions on forums, etc but it seems like there must be a better way! Help appreciated!

[George_Thompson]

You should be able to make a DB connection to the non-geodatabase Postgres DB from ArcGIS Pro. You just need a users with the appropriate permissions: https://pro.arcgis.com/en/pro-app/2.7/help/data/geodatabases/manage-postgresql/privileges-postgresql... 

It may also be good to install PGAdmin on your local machine to test connecting.

[LeslieCooper]

Thanks for your reply. So it looks like I need to be granted superuser status by the DBA in order to create a gdb (which seems necessary?) in ArcPro to establish the connection to the  db?

[George_Thompson]

If you are going to create an Enterprise Geodatabase, you will need the "postgres" user credentials. It will make the SDE user a superuser on the instance.

In order to just connect and view the tables (spatial / non-spatial), you just need grant the permissions in the link above in the section that says "Viewer"

[LeslieCooper]

Hi George, I've established the connection to the postgres db successfully however when I try to create a query table I am unable to see the more than just table names in the db. The thought was that it may be a table name case issue but the names are lowercase and all fields within are lowercase. Is the problem that I am creating a query from a connection and not a gdb? Do I need to create a geodatabase from the postgres db connection first?

TIA!

Leslie

[LeslieCooper]

Thanks again for replying, George. To clarify, I DO NOT need to create an enterprise database in order to query data and view schema, correct? Thanks.

[George_Thompson · Accepted solution]

Hi Leslie - That is correct!

I have non-geodatabases in Postgres that I have data in and can access from ArcGIS Pro / Enterprise with no issues.

[LeslieCooper]

Excellent. Thanks!

Leslie