ArcGIS supports connections to PostgreSQL databases and enterprise geodatabases in PostgreSQL.
Tip:
For ArcGIS releases prior to 10.9 and ArcGIS Pro 2.8, see the system requirements on the ArcGIS Desktop website.
Visit Esri Technical Support for information on the Esri 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 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.
- PostgreSQL 14.5 (64 bit)
- PostGIS 3.2
- PostgreSQL 13.6 (64 bit)
- PostGIS 3.2
- PostgreSQL 12.10 (64 bit)
- PostGIS 3.2
- PostgreSQL 11.15 (64 bit)
- PostGIS 3.2
Note:
Due to changes in data type support beginning with 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 or later. When you use this method to upgrade, it removes unused, unsupported OID fields from geodatabase system tables that would otherwise block you from upgrading PostgreSQL.
Once you upgrade to PostgreSQL 12.x or later, if the database contains a geodatabase, ArcGIS 10.8 and earlier clients and ArcGIS Pro 2.5 and earlier can no longer use the data; you must upgrade your ArcGIS clients.
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.
EDB Postgres Advanced Server
ArcGIS supports EDB Postgres Advanced Server. Supported versions are based on the minimum certified PostgreSQL and PostGIS versions listed in the previous section.
You can use the Create Enterprise Geodatabase geoprocessing tool to create a geodatabase in EDB Postgres Advanced Server. Only the PostGIS spatial type is supported in EDB Postgres Advanced Server, not ST_Geometry.
Supported operating systems for ST_Geometry
The following operating systems have been tested and are the minimum supported version for the ST_Geometry library. If you use a database or geodatabase in PostgreSQL that uses the ST_Geometry type, the PostgreSQL database cluster must be installed on one of these operating systems.
The operating system version and updates you use must also be supported by the operating system provider.
Microsoft Windows
To use the ST_Geometry type in PostgreSQL on Windows, you need the latest Microsoft Visual C++ Redistributable for Visual Studio 2015, 2017, 2019, and 2022 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 2022 Standard and Datacenter | Feb 2023 update |
Windows Server 2019 Standard and Datacenter | Feb 2023 update |
Windows Server 2016 Standard and Datacenter | Feb 2023 update |
Development environments
| Supported operating system | Latest update or service pack tested |
|---|---|
Windows 11 Pro and Enterprise | Feb 2023 update |
Windows 10 Pro and Enterprise | Feb 2023 update |
Note:
- Prior and future updates or service packs for these operating system versions are supported unless otherwise stated. The operating system version and updates must also be supported by the operating system provider.
- Windows 11 and 10 are supported for basic testing and application development use only.
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
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 and ArcGIS Pro.
Only database authenticated connections are supported from ArcGIS to PostgreSQL.