Select to view content in your preferred language

Arcgis Pro Postgresql connection issue

674
5
09-19-2023 01:07 PM
ZOE_U
by
New Contributor II

Hello everyone,

I am trying to connect a PostgreSQL server. The initial connection process goes smoothly, and I can successfully add the connection under the database connections. All tables are populated from the PostgreSQL database as expected. However, I encounter an issue when trying to add the data from the connection to the map; ArcGIS Pro becomes unresponsive and freezes. I am unable to cancel the operation or interact with the software.

I tried the same process with data from my local PostgreSQL connection, and it worked without any problems.

Thank you for any insights or assistance you can provide.

Tags (2)
0 Kudos
5 Replies
George_Thompson
Esri Notable Contributor

What type of data are you adding from the remote PostgreSQL machine?

                 Spatial / Tabular?

Is the data "locally" the same data?

Sound like there is something in the data layer that Pro does not like.

--- George T.
0 Kudos
ZOE_U
by
New Contributor II

I tried to import the same data into my local and connect it to ArcGIS Pro, and encountered no issues. In fact, we've encountered a similar problem with any spatial data from this connection.

0 Kudos
George_Thompson
Esri Notable Contributor

There can be multiple items in play here. I am just trying to get clarity.

I am wondering if there is a PostgreSQL server setting that may be weird.

So no tables (spatial or non-spatial) will load from your remote server?

All local server data works as expected?

--- George T.
0 Kudos
ZOE_U
by
New Contributor II

Yes, when I attempt to load from the remote server, ArcGIS Pro freezes

0 Kudos
George_Thompson
Esri Notable Contributor

I have not encountered this specific behavior before. It may be best to contact Technical Support and work with them on this specific issue.

You could look at this to help troubleshoot: https://pro.arcgis.com/en/pro-app/latest/get-started/arcgis-diagnostic-monitor.htm . I am not well versed in this specific tool.

--- George T.
0 Kudos