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?
Solved! Go to 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.
What version of PostgreSQL do you have installed on your local machine?
Is the postgres DB a geodatabase or just Postgres w/PostGIS?
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
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.
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?
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-...