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

[RiccardoKlinger]

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.

[MarlonAmaya]

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...

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...

Thank you

Marlon

[MarceloMarques]

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 | Documentat...

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

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 | Documentatio...

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

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 Linu...

How to Move the PostgreSQL Enterprise Geodatabase with pg_dump and pg_restore

I hope this clarifies your question.