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.
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.
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.
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?
Yes, when I attempt to load from the remote server, ArcGIS Pro freezes
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.