topic Connecting to PostgreSQL database hosted on Amazon from ArcPro in ArcGIS Pro Questions

Connecting to PostgreSQL database hosted on Amazon from ArcPro

SCVTAGIS — Thu, 16 Feb 2023 20:45:34 GMT

I'm trying to connect to a PostgreSQL database that is hosted on Amazon Web Services using ArcPro. The problem I'm seeing is that after the connection, it only displays the "tiger" files and not the rest of the files or schemas (as shown in the screenshot attached below).

When I make the same connection in QGIS, I'm seeing all the schemas and the correct files that I intend to work with (screenshot below). What am I doing wrong here?

Re: Connecting to PostgreSQL database hosted on Amazon from ArcPro

George_Thompson — Fri, 17 Feb 2023 11:53:43 GMT

What user are you connecting as?

Are you expecting to all the data in all the schemas?

Re: Connecting to PostgreSQL database hosted on Amazon from ArcPro

SCVTAGIS — Fri, 17 Feb 2023 17:06:11 GMT

My user has been granted all administrative privileges.

I am expecting to have the ability to select the schema of my choice, such as the 'inventory' schema, as well as the content contained within it.

Re: Connecting to PostgreSQL database hosted on Amazon from ArcPro

George_Thompson — Fri, 17 Feb 2023 18:22:05 GMT

I do not think that ArcGIS Pro is designed to allow you to pick a schema like that. You would need to grant access to the user and that specific schema. If my memory serves me correctly, we look at the public / sde schema (if it is there) by default.

Is this going to be an Enterprise Geodatabase?

Here is a list of permissions needed for Geodatabases in PostgreSQL and our client: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/privileges-postgresql.htm (in case you have not seen this). There is also a reference to the cloud permissions needed.