ArcGIS Pro 3.1 vs. ArcGIS Enterprise 10.9 vs. PostgreSQL 14

Question

Hi folks,

my organization is in a need to upgrade our PostgreSQL database to a newer version. Currently we are running on Postgres 12 with ArcGIS Pro 2.8 and ArcGIS Enterprise 10.9.1. and installed sde inside the postgre.

Will ArcGIS Enterprise 10.9.1 also be able to use a postgresql 14 with sde enabled coming from an ArcGIS Pro 3.1 installation?

Thanks a lot for your thoughts.

Marcelo Marques · Answer

PostgreSQL 14 is not certified / supported with ArcGIS Enterprise 10.9.1.

Windows: ArcGIS 10.9.1 and ArcGIS Pro 2.9 requirements for PostgreSQL—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

Linux: ArcGIS 10.9.1 and ArcGIS Pro 2.9 requirements for PostgreSQL—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

You need to move to ArcGIS Pro 3.1 & ArcGIS Enterprise 11.1 if you want to go with PostgreSQL 14.

Windows: ArcGIS 11.1 and ArcGIS Pro 3.1 requirements for PostgreSQL—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

Linux: ArcGIS 11.1 and ArcGIS Pro 3.1 requirements for PostgreSQL—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

Important! you need to upgrade the Enterprise Geodatabase Repository with ArcGIS Pro 3.1.

ArcGIS Pro - Upgrade a geodatabase in PostgreSQL

For more information see my white papers in the community.esri.com

How to Upgrade the PostgreSQL and PostGIS version for the Enterprise Geodatabase on Windows and LinuxHow to Move the PostgreSQL Enterprise Geodatabase with pg_dump and pg_restore

I hope this clarifies your question.

MarlonAmaya · Answer

Hi @RiccardoKlinger

ArcGIS Enterprise  10.9.1 does not have PostgreSQL 14.x as a supported release.

* https://enterprise.arcgis.com/en/system-requirements/10.9.1/windows/database-requirements-postgresql.htm

The supportability of PostgreSQL 14.5 begins with ArcGIS Enterprise 11.1 and Pro 3.1

* https://enterprise.arcgis.com/en/system-requirements/latest/windows/database-requirements-postgresql.htm

Thank you

Marlon