Installing Percona Distribution for PostgreSQL

Using repositories provided by Percona is the recommended way of installing Percona Distribution for PostgreSQL. Installation packages are available in the RPM format for Red Hat, CentOS, and Amazon Linux AMI as well as in the DEB format for Ubuntu and Debian distributions). Percona Distribution for PostgreSQL is only available for the x86_64 platform (also known as amd64).

Like many other Percona products, Percona Distribution for PostgreSQL is installed by using the percona-release utility.

Important

Before you attempt to install Percona Distribution for PostgreSQL, reinstall percona-release to get its latest version.

See also

Documentation of percona-release: Installation
https://www.percona.com/doc/percona-repo-config/percona-release.html

As soon as percona-release is ready, set up the Percona Distribution for PostgreSQL product (ppg-11).

$ sudo percona-release setup ppg11

Make sure to run percona-release as root or via sudo. For the sake of convenience, all commands that require elevated priviges start with sudo in the following procedures.

Hint

You can also make the packages related to Percona Distribution for PostgreSQL available by enabling the dedicated repository:

$ sudo percona-release enable ppg-11 release

Install |ppd| using the commands of your package manager (the precedure differs depending on the package manager of your operating system).

Using the DEB Format

Important

On Debian and other systems that use the apt package manager, such as Ubuntu, components of Percona Distribution for PostgreSQL 11 can only be installed together with the server shipped by Percona (percona-postgresql-11). If you wish to use Percona Distribution for PostgreSQL uninstall the PostgreSQL package provided by your distribution (postgresql-11) and then install the chosen components from Percona Distribution for PostgreSQL.

Install the percona-postgresql-11 package using apt install.

$ sudo apt install percona-postgresql-11

Note that this package will not install the components. To install these components use the appropriate packages:

$ # To install pg_repack
$ sudo apt-get install percona-postgresql-11-repack
$ # To Install pgaudit
$ sudo apt-get install percona-postgresql-11-pgaudit
$ # To install pgBackRest
$ sudo apt-get install percona-pgbackrest
$ # To install Patroni
$ sudo apt-get install percona-patroni
$ # To install PostgreSQL contrib extensions
$ sudo apt-get install percona-postgresql-contrib

The following platforms are supported:

  • Debian 9.0 (stretch)
  • Debian 10.0 (buster)
  • Ubuntu 18.04 LTS (bionic)

Platform Specific Notes

On Debian 9 (stretch), you need to enable the llvm repository

Using the RPM Format

Install the percona-postgresql-11 package using yum install.

$ sudo yum install percona-postgresql11-server

Note that this package will not install the components. To install these components use the appropriate packages:

$ # To install pg_repack
$ sudo yum install percona-pg_repack11
$ # To Install pgaudit
$ sudo yum install percona-pgaudit
$ # To install pgBackRest
$ sudo yum install percona-pgbackrest
$ # To install Patroni
$ sudo yum install percona-patroni
$ # To install PostgreSQL contrib extensions
$ sudo yum install percona-postgresql11-contrib

The following platforms are supported:

  • CentOS 7 and Red Hat Enterprise Linux 7
  • Red Hat Enterprise Linux 8

Platform Specific Notes

If you intend to install Percona Distribution for PostgreSQL on Red Hat Enterprise Linux v8, disable the postgresql module:

$ sudo dnf module disable postgresql

On CentOS 7, you should install the epel-release package:

$ sudo yum -y install epel-release
$ sudo yum repolist