Skip to content
logo
Percona Product Documentation
Upgrade spatial database
Initializing search
    percona/postgresql-docs
    percona/postgresql-docs
    • Home
        • Overview
        • Install on Debian and Ubuntu
        • Install on RHEL and derivatives
        • Enable Percona Distribution for PostgreSQL extensions
        • Repositories overview
      • Migrate from PostgreSQL to Percona Distribution for PostgreSQL
      • Upgrading Percona Distribution for PostgreSQL from 12 to 13
      • Minor Upgrade of Percona Distribution for PostgreSQL
      • pg_stat_monitor
        • High availability
        • Deploying on Debian or Ubuntu
        • Deploying on RHEL or derivatives
        • pgBackRest setup
        • Testing the Patroni PostgreSQL Cluster
        • Backup and disaster recovery
        • Deploying backup and disaster recovery solution in Percona Distribution for PostgreSQL
        • Overview
        • Deployment
        • Query spatial data
        • Upgrade spatial database
          • Upgrade PostGIS
          • Upgrade PostgreSQL
      • LDAP authentication
    • Uninstall
      • Release notes index
      • Percona Distribution for PostgreSQL 13.12 (2023-08-30)
      • Percona Distribution for PostgreSQL 13.11 (2023-06-29)
      • Percona Distribution for PostgreSQL 13.10 Update (2023-05-22)
      • Percona Distribution for PostgreSQL 13.10 (2023-03-27)
      • Percona Distribution for PostgreSQL 13.9 (2022-11-24)
      • Percona Distribution for PostgreSQL 13.8 (2022-09-06)
      • Percona Distribution for PostgreSQL 13.7 (2022-06-02)
      • Percona Distribution for PostgreSQL 13.6 Second Update (2022-05-05)
      • Percona Distribution for PostgreSQL 13.6 Update (2022-04-14)
      • Percona Distribution for PostgreSQL 13.6 (2022-03-22)
      • Percona Distribution for PostgreSQL 13.5 Second Update (2021-12-07)
      • Percona Distribution for PostgreSQL 13.5 Update (2021-02-12)
      • Percona Distribution for PostgreSQL 13.5 (2021-11-23)
      • Percona Distribution for PostgreSQL 13.4 Update (2021-09-30)
      • Percona Distribution for PostgreSQL 13.4 (2021-09-09)
      • Percona Distribution for PostgreSQL 13.3 Third Update (2021-07-15)
      • Percona Distribution for PostgreSQL 13.3 Second Update (2021-07-01)
      • Percona Distribution for PostgreSQL 13.3 Update (2021-06-10)
      • Percona Distribution for PostgreSQL 13.3 (2021-05-20)
      • Percona Distribution for PostgreSQL 13.2 Fourth Update (2021-06-10)
      • Percona Distribution for PostgreSQL 13.2 Third Update (2021-05-10)
      • Percona Distribution for PostgreSQL 13.2 Second Update (2021-04-27)
      • Percona Distribution for PostgreSQL 13.2 Update (2021-04-12)
      • Percona Distribution for PostgreSQL 13.2 (2021-03-04)
      • Percona Distribution for PostgreSQL 13.1 (2020-12-02)
      • Percona Distribution for PostgreSQL 13.0 (2020-10-16)
    • Licensing
    • Trademark policy

    • Upgrade PostGIS
    • Upgrade PostgreSQL

    Spatial database upgrade¶

    When using PostgreSQL and PostGIS for some time, you may eventually come to the decision to upgrade your spatial database. There can be different reasons for that: to receive improvements and/or bug fixes that come with a minor version of the database/extension, reaching the end of life of the currently used software and others.

    The spatial database upgrade consists of two steps:

    • upgrade of PostgreSQL, and
    • upgrade of the PostGIS extension.

    Important

    Before the upgrade, backup your data.

    Upgrade PostGIS¶

    Each version of PostGIS is compatible with several versions of PostgreSQL and vise versa. The best practice is to first upgrade the PostGIS extension on the source cluster to match the compatible version on the target cluster and then upgrade PostgreSQL. Please see the PostGIS Support matrix for version compatibility.

    PostGIS is enabled on the database level. This means that the upgrade is also done on the database level.

    Connect to the database where it is enabled and run the PostGIS_Extensions_Upgrade() function:

    SELECT postgis_extensions_upgrade();
    

    Repeat these steps to upgrade PostGIS on every database where it is enabled.

    Connect to the database with the enabled extension and run the following commands:

    ALTER EXTENSION postgis UPDATE;
    SELECT postgis_extensions_upgrade();
    

    Starting with version 3, vector and raster functionalities have been separated in two individual extensions. Thus, to upgrade those, you need to run the postgis_extensions_upgrade(); twice.

    SELECT postgis_extensions_upgrade();
    

    TIP: If you don’t need the raster functionality, you can drop the postgis_raster extension after the upgrade.

    Repeat these steps to upgrade PostGIS on every database where it is enabled.

    Upgrade PostgreSQL¶

    Upgrade PostgreSQL either to the latest minor or to the major version.

    If you are using long deprecated views and functions and / or need the expertise in upgrading your spatial database, contact Percona Managed Services for an individual upgrade scenario development.

    Contact Us

    For free technical help, visit the Percona Community Forum.

    To report bugs or submit feature requests, open a JIRA ticket.

    For paid support and managed or consulting services , contact Percona Sales.


    Last update: June 29, 2023
    Created: June 29, 2023
    Percona LLC, © 2023
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better. Read more about Percona Cookie Policy.