topic Re: Any Update for ST_geometry library for PostgreSQL 16? in ArcGIS Pro Questions

Any Update for ST_geometry library for PostgreSQL 16?

KumbiraiMatingo — Mon, 29 Jan 2024 07:47:27 GMT

I have been struggling with Importing a feature service into a PostgreSQL connection until I came across this article - https://pro.arcgis.com/en/pro-app/latest/help/data/databases/add-the-st-geometry-type-to-a-postgresql-database.htm which talks about adding the ST_Geometry library to the PostgreSQL installation path.

Unfortunately, the available ST_Geometry library only supports up to Version 15 of PostgreSQL. I currently have PostgreSQL 16 installed and I cannot seem to find a way around this.

Anyone to help out on this? Downgrading from Version 16 to 15 is the only last option at this moment.

Re: Any Update for ST_geometry library for PostgreSQL 16?

George_Thompson — Mon, 29 Jan 2024 11:48:06 GMT

At this point in time, we only support up to PostgreSQL 15.x; https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql.htm

I am not sure when PostgreSQL 16.x will be supported in the future. I would guess that it will be at a future release to be determined.

Moving to a supporting PostgreSQL version, like 15.5 would get you in a place to use the st-geometry library.

Re: Any Update for ST_geometry library for PostgreSQL 16?

KumbiraiMatingo — Mon, 29 Jan 2024 12:16:21 GMT

Thanks, George. I guess I have no other option than to do this.

Re: Any Update for ST_geometry library for PostgreSQL 16?

George_Thompson — Mon, 29 Jan 2024 12:18:37 GMT

Unfortunately, that is the only option at this time.