Frequently asked question
Usually, in-place upgrades of PostgreSQL can be performed using pg_upgrade, however, due to changes in data type support beginning with PostgreSQL 12.x, if the database contains a geodatabase, you must use the pg_dump and pg_restore commands to upgrade to PostgreSQL 12.x or later. When using this method to upgrade, it removes unused, unsupported OID fields from geodatabase system tables that would otherwise prevent upgrading PostgreSQL.
Esri recommends using pg_dump to create an archive file, drop the database, re-create the database with the same name, and restore the archive file to the re-created database using pg_restore.
Note: When restoring the PostgreSQL database, you can restore the pg_dump file to a newer version of PostgreSQL. Because pg_dump is used to transfer data to newer versions of PostgreSQL, the output of pg_dump can be expected to load into PostgreSQL server versions newer than pg_dump's version.
Get help from ArcGIS experts
Download the Esri Support App