PostgreSQL database requirements for ArcGIS 10.6.x and ArcGIS Pro 2.1 and 2.2

Visit Esri Support for general support information on Esri's Supported Environment Policy.

Minimum supported database versions

The following versions of PostgreSQL and PostGIS are supported with ArcGIS. The specific versions listed are the minimum minor version supported and certified for each supported major release of PostgreSQL. Newer minor versions are supported but are not certified. Pursuant to the PostgreSQL definition, the number in the y position denotes a minor version in a PostgreSQL 9.x.y release. For PostgreSQL 10.x, the number in the x position indicates a minor version.

• PostgreSQL 10.3 (64 bit)*
  • PostGIS 2.4
• PostgreSQL 9.6.8 (64 bit)
  • PostGIS 2.3
• PostgreSQL 9.5.12 (64 bit)**
  • PostGIS 2.2
• PostgreSQL 9.4.8 (64 bit)***
  • PostGIS 2.2

*Support begins at ArcGIS 10.6.1 and ArcGIS Pro 2.2.

**The minimum supported release for ArcGIS 10.6.1 and ArcGIS Pro 2.2 is PostgreSQL 9.5.12.

***Support ends after ArcGIS 10.6 and ArcGIS Pro 2.1.

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.

Windows

For PostgreSQL on Windows, you need the latest Visual Studio VC++ 2017 installed on the PostgreSQL machine. See The latest supported Visual C++ downloads from Microsoft Support for more information.

Supported operating systems	Latest update or service pack tested
Windows Server 2019 Standard and Datacenter	Nov 2018 Release
Windows Server 2016 Standard and Datacenter	April 10, 2018
Windows Server 2012 R2 Standard and Datacenter	May 8, 2018
Windows Server 2012 Standard and Datacenter	May 8, 2018
Windows Server 2008 R2 Standard, Enterprise, and Datacenter	SP1 with May 8, 2018 update

Note:

Windows 10, 8.1, and 7 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 systems	Latest update or service pack tested
Red Hat Enterprise Linux Server 7	Update 4
Red Hat Enterprise Linux Server 6	Update 9
SUSE Linux Enterprise Server 12	Service Pack 2
SUSE Linux Enterprise Server 11	Service Pack 4
Ubuntu Server LTS	16.04.3

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 version. As a prerequisite for logging a defect, any software issue on these operating systems will be attempted to be reproduced on Red Hat Enterprise Linux. For Oracle Linux, support is predicated on the use of the Red Hat compatible kernel.

Database requirements and limitations

Use of the PostGIS geography type with ArcGIS requires PostgreSQL 9.6.8 and later.

Branch versioning is supported at PostgreSQL 9.5.3 and later.

Software required to connect to a DBMS

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

Esri tests and certifies specific major and minor releases of 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.