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

On Debian and Ubuntu LinuxOn RHEL and compatible derivatives

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.

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 ppg11
   

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.

1. Stop the postgresql server

   $ sudo systemctl stop postgresql-11
   

2. Remove community packages

   $ sudo yum remove postgresql
   

3. Install percona-release

4. Enable the repository

   $ sudo percona-release setup ppg11
   

5. Install Percona Distribution for PostgreSQL packages

6. (Optional) Restore the data from the backup.

7. Start the postgresql service

   $ sudo systemctl start postgresql-11
   

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

   On Debian and UbuntuOn RHEL and derivatives

   $ sudo systemctl stop postgresql.service
   

   $ sudo systemctl stop postgresql-11
   

3. Optionally, remove PostgreSQL Community packages

On the target server:

1. Install percona-release

2. Enable the repository

   $ sudo percona-release setup ppg11
   

3. Install Percona Distribution for PostgreSQL packages on the target server.

4. Restore the data from the backup

5. Start postgresql service

   On Debian and UbuntuOn RHEL and compatible derivatives

   $ sudo systemctl start postgresql.service
   

   $ sudo systemctl start postgresql-11
   

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.