PostgreSQL database requirements for ArcGIS 10.8.x and ArcGIS Pro 2.5, 2.6, and 2.7

Visit Esri Support for information on the Esri Supported Environment Policy.

Minimum supported database versions

The following three sections list the versions of PostgreSQL and PostGIS that are supported with the specified ArcGIS releases. The versions listed are the minimum minor version supported and certified for each supported major release of PostgreSQL and PostGIS. Newer minor versions are supported but are not certified unless otherwise stated. The PostgreSQL version and updates must also be supported by the PostgreSQL Global Development Group.

Pursuant to the PostgreSQL definition, the number in the y position of the PostgreSQL version denotes a minor version in a PostgreSQL 9.x.y release. For PostgreSQL 10.x and later releases, the number in the x position indicates a minor version.

Esri tests and certifies PostgreSQL installations that are available from PostgreSQL.org. For each PostgreSQL release that Esri supports, available PostGIS modules are also tested and certified. No other modules extending PostgreSQL functionality are included in Esri certification.

ArcGIS 10.8 and ArcGIS Pro 2.5

ArcGIS 10.8 and ArcGIS Pro 2.5 support the following PostgreSQL and PostGIS release combinations:

• PostgreSQL 9.6.15 (64 bit)
  • PostGIS 2.3
• PostgreSQL 10.12 (64 bit)
  • PostGIS 3.0.1
• PostgreSQL 11.7 (64 bit)
  • PostGIS 3.0.1

ArcGIS 10.8.1 and ArcGIS Pro 2.6

ArcGIS 10.8.1 and ArcGIS Pro 2.6 support the following PostgreSQL releases and PostGIS 3.0.1:

• PostgreSQL 9.6.17 (64 bit)
• PostgreSQL 10.12 (64 bit)
• PostgreSQL 11.7 (64 bit)
• PostgreSQL 12.2 (64 bit)

Note:

Due to changes in data type support in PostgreSQL 12.x, if your database contains a geodatabase, you must use the pg_dump and pg_restore commands to upgrade to PostgreSQL 12.x. When you use this method to upgrade, it removes unused, unsupported OID fields from geodatabase system tables that would otherwise block you from upgrading to PostgreSQL 12.x.

Once you upgrade to PostgreSQL 12.x, if the database contains a geodatabase, older ArcGIS clients can no longer use the data; you must upgrade your ArcGIS clients.

ArcGIS Pro 2.7

ArcGIS Pro 2.7 supports the following PostgreSQL releases and PostGIS 3.0.1:

• PostgreSQL 10.14 (64 bit)
• PostgreSQL 11.9 (64 bit)
• PostgreSQL 12.4 (64 bit)

Note:

Due to changes in data type support in PostgreSQL 12.x, if your database contains a geodatabase, you must use the pg_dump and pg_restore commands to upgrade to PostgreSQL 12.x. When you use this method to upgrade, it removes unused, unsupported OID fields from geodatabase system tables that would otherwise block you from upgrading to PostgreSQL 12.x.

Once you upgrade to PostgreSQL 12.x, if the database contains a geodatabase, older ArcGIS clients can no longer use the data; you must upgrade your ArcGIS clients.

Supported operating systems

If you use a geodatabase in PostgreSQL or use the ST_Geometry type in a PostgreSQL database, the following operating systems have been tested and are the minimum supported version. Future updates or service packs on these operating system versions are supported and assumed to work unless otherwise stated. The operating system version and updates must also be supported by the operating system provider.

Microsoft Windows

To use a geodatabase or the ST_Geometry type in PostgreSQL on Windows, you need the latest Microsoft Visual C++ Redistributable for Visual Studio 2015, 2017, and 2019 installed on the PostgreSQL machine. See the latest supported Visual C++ downloads from Microsoft support for more information.

Supported operating system	Latest update or service pack tested
Windows Server 2019 Standard and Datacenter	June 2020 updates
Windows Server 2016 Standard and Datacenter	June 2020 updates
Windows Server 2012 R2 Standard and Datacenter	June 2020 updates
Windows Server 2012 Standard and Datacenter	June 2020 updates

Prior and future updates or service packs on these operating system versions are supported unless otherwise stated. The operating system version and updates must also be supported by the operating system provider.

Note:

The Desktop Experience option is required on all versions of Windows Server.

Supported operating system	Latest update or service pack tested
Windows 10 Pro and Enterprise (64 bit [EM64T])	June 2020 updates
Windows 8.1 Pro and Enterprise (64 bit [EM64T])	June 2020 updates

Note:

Windows 10 and 8.1 are supported for basic testing and application development use only. They are not recommended for deployment in a production environment.

Linux

The following Linux operating systems have been tested:

Supported operating system	Latest update or service pack tested
Red Hat Enterprise Linux Server 8 (supported with 10.8.1 only)	Update 1
Red Hat Enterprise Linux Server 7	Update 8
Red Hat Enterprise Linux Server 6	Update 10
SUSE Linux Enterprise Server 15 (supported with 10.8.1 only)	Service Pack 1
SUSE Linux Enterprise Server 12	Service Pack 5
Ubuntu Server 20.04 LTS	20.04.1
Ubuntu Server 18.04 LTS	18.04.4
Ubuntu Server 16.04 LTS	16.04.6

Prior and future updates or service packs on these operating system versions are supported unless otherwise stated. The operating system version and updates must also be supported by the operating system provider.

Note:

Esri Technical Support is available for CentOS, Scientific Linux, and Oracle Linux versions that provide full binary compatibility with an equivalent supported Red Hat Enterprise Linux Server version. As a prerequisite for logging a software defect, Esri Support will attempt to reproduce the issue on Red Hat Enterprise Linux Server. For Oracle Linux, support is predicated on the use of the Red Hat Enterprise Linux Server compatible kernel.

Cloud support

See Requirements for using ArcGIS with databases in the cloud for information on support for database services and databases deployed in the cloud.

Connections to PostgreSQL

Most ArcGIS applications that can connect to a PostgreSQL database contain the PostgreSQL client libraries that are required to make a connection. These applications include ArcGIS Server, ArcGIS Pro, ArcGIS Desktop, and ArcReader.

Only database authenticated connections are supported from ArcGIS to PostgreSQL.