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. As soon as it is ready, enable Percona Distribution for PostgreSQL and then install using the commands of your package manager.

Important

Before you attempt to install Percona Distribution for PostgreSQL, update percona-release to its latest version. For the steps described in this section to succeed, percona-release must be version 1.0.12 or later.

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.

$ sudo percona-release setup ppg-11

The next steps depend on the installation package format that your operating system supports.

Using the DEB Format

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

$ sudo apt install percona-postgresql-11

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

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