topic Re: PostgreSQL connection does not show files in database in ArcGIS Pro 3.0 in ArcGIS Pro Questions

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

DestinyKelley1 — Mon, 26 Sep 2022 14:02:23 GMT

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?

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

George_Thompson — Mon, 26 Sep 2022 14:11:11 GMT

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

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

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

DestinyKelley1 — Mon, 26 Sep 2022 14:36:25 GMT

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

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

George_Thompson — Mon, 26 Sep 2022 14:48:01 GMT

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.htm

So I wonder if that is the issue.

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

DestinyKelley1 — Mon, 26 Sep 2022 15:01:30 GMT

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?

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

George_Thompson — Mon, 26 Sep 2022 15:55:53 GMT

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-of-postgresql