topic Re: Arcgis Pro Postgresql connection issue in ArcGIS Pro Questions

Arcgis Pro Postgresql connection issue

ZOE_U — Tue, 19 Sep 2023 20:07:42 GMT

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.

Re: Arcgis Pro Postgresql connection issue

George_Thompson — Tue, 19 Sep 2023 21:13:12 GMT

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.

Re: Arcgis Pro Postgresql connection issue

ZOE_U — Wed, 20 Sep 2023 12:02:33 GMT

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.

Re: Arcgis Pro Postgresql connection issue

George_Thompson — Wed, 20 Sep 2023 12:18:28 GMT

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?

Re: Arcgis Pro Postgresql connection issue

ZOE_U — Wed, 20 Sep 2023 12:52:11 GMT

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

Re: Arcgis Pro Postgresql connection issue

George_Thompson — Wed, 20 Sep 2023 14:02:17 GMT

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.