Arc GIS Pro 10.6.1 : Postgres compatibility

GDT-Younup · ‎02-24-2023

Hello,

I'm looking for Postgresql versions that are compatible with our ArcGIS Pro 10.6.1 version, but I can't find a clear information on the web documentation 😞

On https://desktop.arcgis.com/en/system-requirements/10.6/database-requirements-postgresql.htm it says that minimum supported database versions is PostgreSQL 10.3 & PostGIS 2.4.
But the final version of Postgres 10.x has been released on Nov. 2022. Does "minimum supported" means that all latest versions are supported ?

Ideally we would like to migrate our data on the lastest PostgreSQL / PostGIS version (15.x / 3.x). Does our 10.6 ArcGIS version can run and has support on theses versions ?

Thanks.

VinceAngelo · ‎02-24-2023

The PostgreSQL dev team modified their release naming after 9.6, making 10.x the next major release, then 11.x, etc (currently at 15, having just released 15.2, 14.7, 13.10, 12.14 and 11.19).

Esri generally supports the "current" build (as of development start), plus three back. So ArcGIS 10.6 (the oldest currently maintained release) supports PG 10, PG 9.6, PG 9.5, and PG 9.4. Each supported release has a "minimum" build (the one developed against), but minor updates are also supported (unless explicitly noted due to breaking change). For ArcGIS 10.6.1, those minimums are PG 10.3, 9.6.8, 9.5.12, and 9.4.8 (all of which are no longer supported by the PG dev team). PG 11 is not supported (at all) with ArcGIS 10.6.x.

Esri support for PostgreSQL generally increases to the "most recent" release with each ArcGIS major release to the active PostgreSQL release, so ArcGIS 10.7+PG11, ArcGIS 10.8+PG12, and ArcGIS 10.9+PG13. ArcGIS 11.0 still only lists PG13, but PG14 might be added with the terminal 11.0 snapshot (and/or 11.1). PG 15 is not yet shown as supported.

Note that there was a breaking change between PG 11 and PG12, where support for WITH OIDS=TRUE was removed. The ArcGIS releases which support PG12 and higher are documented as needing a pg_dump|pg_restore migration from PG11.

If you're currently at PG 10.3 with ArcGIS 10.6.1, you probably need to upgrade ArcGIS to 10.7.1 or 10.8.1 (to make PG11 and/or PG12 available), then upgrade PG10 to PG11 (or PG 12), then upgrade ArcGIS again to 10.9/11, before upgrading PostgreSQL to 13.x. I wouldn't recommend changing both ArcGIS and PG releases at the same time without a full export/import migration (which is useful at times, but requires a lot of work).

- V

View solution in original post

George_Thompson · ‎02-24-2023

There are a few things to unpack.

1. ArcGIS 10.6.x would support the latest Postgres 10.23 since it is higher than the listed version. It does not mean that Esri certifies that version on 10.6.1. It just follows our Supported Environment Policy: https://support.esri.com/en/white-paper/3521

2. ArcGIS 10.6.x is now in Mature support and going to be retired Dec. 2023: https://support.esri.com/en/Products/Enterprise/arcgis-server/ArcGIS-Server/10-6-1#product-support

I would look at upgrading to a newer version, like 10.9.1 / 11.0 or 11.1 (to be released in the near future) ASAP.

I do not know if 11.1 will support PostgreSQL 15.x / PostGIS 3.x. I know that we support 13.x right now with Pro 3.1 / Enterprise 11.0. PostgreSQL 15.x was just released in October 2022.

3. Your 10.6.1 probably would not run correctly if you upgraded to PostgreSQL 15.x / PostGIS 3.x. 10.6.1 was released in July 2018, almost 5 years ago.

--- George T.

VinceAngelo · ‎02-24-2023

The PostgreSQL dev team modified their release naming after 9.6, making 10.x the next major release, then 11.x, etc (currently at 15, having just released 15.2, 14.7, 13.10, 12.14 and 11.19).

Esri generally supports the "current" build (as of development start), plus three back. So ArcGIS 10.6 (the oldest currently maintained release) supports PG 10, PG 9.6, PG 9.5, and PG 9.4. Each supported release has a "minimum" build (the one developed against), but minor updates are also supported (unless explicitly noted due to breaking change). For ArcGIS 10.6.1, those minimums are PG 10.3, 9.6.8, 9.5.12, and 9.4.8 (all of which are no longer supported by the PG dev team). PG 11 is not supported (at all) with ArcGIS 10.6.x.

Esri support for PostgreSQL generally increases to the "most recent" release with each ArcGIS major release to the active PostgreSQL release, so ArcGIS 10.7+PG11, ArcGIS 10.8+PG12, and ArcGIS 10.9+PG13. ArcGIS 11.0 still only lists PG13, but PG14 might be added with the terminal 11.0 snapshot (and/or 11.1). PG 15 is not yet shown as supported.

Note that there was a breaking change between PG 11 and PG12, where support for WITH OIDS=TRUE was removed. The ArcGIS releases which support PG12 and higher are documented as needing a pg_dump|pg_restore migration from PG11.

If you're currently at PG 10.3 with ArcGIS 10.6.1, you probably need to upgrade ArcGIS to 10.7.1 or 10.8.1 (to make PG11 and/or PG12 available), then upgrade PG10 to PG11 (or PG 12), then upgrade ArcGIS again to 10.9/11, before upgrading PostgreSQL to 13.x. I wouldn't recommend changing both ArcGIS and PG releases at the same time without a full export/import migration (which is useful at times, but requires a lot of work).

- V