Skip to content

Migrate from PostgreSQL to Percona Distribution for PostgreSQL

Percona Distribution for PostgreSQL includes the PostgreSQL database and additional extensions that have been selected to cover the needs of the enterprise and are guaranteed to work together. Percona Distribution for PostgreSQL is available as a software collection that is easy to deploy.

We encourage users to migrate from their PostgreSQL deployments based on community binaries to Percona Distribution for PostgreSQL. This document provides the migration instructions.

Depending on your business requirements, you may migrate to Percona Distribution for PostgreSQL either on the same server or onto a different server.

Migrate on the same server

To ensure that your data is safe during the migration, we recommend to make a backup of your data and all configuration files (such as pg_hba.conf, postgresql.conf, postgresql.auto.conf) using the tool of your choice. The backup process is out of scope of this document. You can use pg_dumpall or other tools of your choice. For more information, see the blog post PostgreSQL Upgrade Using pg_dumpall by Avinash Vallarapu, Fernando Laudares Camargos, Jobin Augustine and Nickolay Ihalainen.

Run all commands as root or via sudo:

  1. Stop the postgresql server

    $ sudo systemctl stop postgresql.service
    
  2. Remove community packages

    $ sudo apt-get --purge remove postgresql
    
  3. Install percona-release

  4. Enable the repository

    $ sudo percona-release setup ppg14
    
  5. Install Percona Distribution for PostgreSQL packages

  6. (Optional) Restore the data from the backup.
  7. Start the postgresql service. The installation process starts and initializes the default cluster automatically. You can check its status with:

    $ sudo systemctl status postgresql
    

    If postresql service is not started, start it manually:

    $ sudo systemctl start postgresql.service
    

To ensure that your data is safe during the migration, we recommend to make a backup of your data and all configuration files (such as pg_hba.conf, postgresql.conf, postgresql.auto.conf) using the tool of your choice. The backup process is out of scope of this document. You can use pg_dumpall or other tools of your choice.

Run all commands as root or via sudo:

  1. Stop the postgresql server

    $ sudo systemctl stop postgresql-14
    
  2. Remove community packages

    $ sudo yum remove postgresql
    
  3. Install percona-release

  4. Enable the repository

    $ sudo percona-release setup ppg14
    
  5. Install Percona Distribution for PostgreSQL packages

  6. (Optional) Restore the data from the backup.
  7. Start the postgresql service

    $ sudo systemctl start postgresql-14
    

Migrate on a different server

In this scenario, we will refer to the server with PostgreSQL Community as the “source” and to the server with Percona Distribution for PostgreSQL as the “target”.

To migrate from PostgreSQL Community to Percona Distribution for PostgreSQL on a different server, do the following:

On the source server:

  1. Back up your data and all configuration files (such as pg_hba.conf, postgresql.conf, postgresql.auto.conf) using the tool of your choice.
  2. Stop the postgresql service

    $ sudo systemctl stop postgresql.service
    
    $ sudo systemctl stop postgresql-14
    
  3. Optionally, remove PostgreSQL Community packages

On the target server:

  1. Install percona-release
  2. Enable the repository

    $ sudo percona-release setup ppg14
    
  3. Install Percona Distribution for PostgreSQL packages on the target server.

  4. Restore the data from the backup
  5. Start postgresql service

    $ sudo systemctl start postgresql.service
    
    $ sudo systemctl start postgresql-14
    

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.