PostgreSQL connection does not show files in database in ArcGIS Pro 3.0

[DestinyKelley1]

I am trying to connect a PostgreSQL/PostGIS database to ArcGIS Pro 3.0.  When I make the connection, no error messages appear, so I believe the connection was successful.  However, when I double click the database connection, no files are present.  I have several tables present in the database.  I have provided screenshots.  What should I do?

[George_Thompson]

What version of PostgreSQL do you have installed on your local machine?

Is the postgres DB a geodatabase or just Postgres w/PostGIS?

[DestinyKelley1]

The version I have on my machine is PostgreSQL 14.5.  I do not know if the postgres is a geodatabase, but I have provided a screenshot below.  How do I determine this?  Thank you

[George_Thompson · Accepted solution]

Ah, ok. To determine the version in PGAdmin, open a query window and run either of the queries below:

show server_version; or show server_version_num;

ArcGIS Pro does not support PostgreSQL 14.x at this time: https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql...

So I wonder if that is the issue.

[DestinyKelley1]

I run the query and the current server version is 14.5.

Can I simultaneously install PostgreSQL 13.6 (64 bit) / PostGIS 3.2 without uninstalling the current versions, and then import the database to the earlier versions? Or do I have to re-add the tables?

[George_Thompson]

I believe that you can multiple versions of PostgreSQL on the same machine. As for importing the DB, I am not sure about that. Especially if it is from a newer version.

You maybe able to export to a CSV or something, then import into the older one.

Just some info I found: https://www.postgresql.org/docs/14/app-pgdump.html

Because pg_dump is used to transfer data to newer versions of PostgreSQL, the output of pg_dump can be expected to load into PostgreSQL server versions newer than pg_dump's version. pg_dump can also dump from PostgreSQL servers older than its own version. (Currently, servers back to version 8.0 are supported.) However, pg_dump cannot dump from PostgreSQL servers newer than its own major version; it will refuse to even try, rather than risk making an invalid dump. Also, it is not guaranteed that pg_dump's output can be loaded into a server of an older major version — not even if the dump was taken from a server of that version. Loading a dump file into an older server may require manual editing of the dump file to remove syntax not understood by the older server. Use of the --quote-all-identifiers option is recommended in cross-version cases, as it can prevent problems arising from varying reserved-word lists in different PostgreSQL versions.

https://stackoverflow.com/questions/33594039/pg-dump-and-pg-restore-across-different-major-versions-...