nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

2022-09-26 (1).png

Find more posts tagged with

Geodatabase

Accepted answers

George Thompson

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.

All comments

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

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.

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

2022-09-26 (2).png

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.