topic Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema in Data Management Questions

connection to PostGresSQL db with Pro 3.2.2 only shows public schema

JasonFitzsimmons — Tue, 30 Apr 2024 15:04:11 GMT

I am trying to connect to a PostgreSQL database that has a few schemas, including public. In Pro we can only see the public schema.

Using the same credentials in PGadmin, I can see all the schemas and all the tables and views in each one.

Something else missing?

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

George_Thompson — Tue, 30 Apr 2024 16:41:44 GMT

What version of Pro and PostgreSQL are you using?

Does the user have "superuser" assigned?

What are the permissions of the user in question: https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-postgresql/privileges-postgresql.htm?

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

JasonFitzsimmons — Tue, 30 Apr 2024 17:27:56 GMT

Pro 3.2.2
PostGreSQL 13.4
Its a read only account, we have admin too, but the use case only needs to view the data and not edit (Data Viewer role) with the same account and same credentials, I can see all the schemas

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

George_Thompson — Tue, 30 Apr 2024 17:37:37 GMT

I wonder if there is an issue with the version of PostgreSQL you have. With Pro 3.2.x, the minimum supported version at v13.x is 12 (https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql.htm). That could cause an issue.

I would update PostgreSQL to 13.12 (or newer) and then retest.

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

JasonFitzsimmons — Tue, 30 Apr 2024 17:41:55 GMT

I am a little unclear about that list, I see

PostgreSQL 12.16 (64 bit)
- PostGIS 3.3

as a minimum requirement?
but it's true that we haven't updated in a while.

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

George_Thompson — Tue, 30 Apr 2024 18:37:53 GMT

Here are the min. versions for Pro 3.2.x:

Each major version of PostgreSQL (12, 13, 14, 15, etc..) are different from each other and have minor "updates" (.x) for each major version.

Herer is the link to the latest supported versions for windows: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

Hope that helps.

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

MarceloMarques — Tue, 30 Apr 2024 19:12:10 GMT

@JasonFitzsimmons -

How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Windows
How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Linux

How to Move the PostgreSQL Enterprise Geodatabase with pg_dump and pg_restore

PostgreSQL Geodatabase Guide Books and Database Template scripts.

Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community

use the Production Mapping guidebook for PostgreSQL, the best practices can be used by any industry.

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

JasonFitzsimmons — Tue, 30 Apr 2024 19:00:33 GMT

thanks!

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

JasonFitzsimmons — Tue, 30 Apr 2024 19:01:03 GMT

ok thanks!

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

JasonFitzsimmons — Wed, 01 May 2024 16:34:13 GMT

curiously, I only see the public schema when i connect using ArcGIS (stand alone) catalog 10.8.2 as well.

topic Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema in Data Management Questions

connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Pro 3.2.2 PostGreSQL 13.4Its a read only account, we have admin too, but the use case only needs to view the data and not edit (Data Viewer role) with the same account and same credentials, I can see all the schemas

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Re: connection to PostGresSQL db with Pro 3.2.2 only shows public schema

Pro 3.2.2
PostGreSQL 13.4
Its a read only account, we have admin too, but the use case only needs to view the data and not edit (Data Viewer role) with the same account and same credentials, I can see all the schemas