Install Percona Distribution for PostgreSQL on Red Hat Enterprise Linux and derivatives

This document describes how to install Percona Server for PostgreSQL from Percona repositories on RPM-based distributions such as Red Hat Enterprise Linux and compatible derivatives..

Platform specific notes

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

$ sudo dnf module disable postgresql llvm-toolset

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

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

Procedure

Run all the commands in the following sections as root or using the sudo command:

Configure the repository

1. Install the percona-release repository management tool to subscribe to Percona repositories:

   $ sudo yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm
   

2. Enable the repository

Percona provides two repositories for Percona Distribution for PostgreSQL. We recommend enabling the Major release repository to timely receive the latest updates.

To enable a repository, we recommend using the setup command:

$ sudo percona-release setup ppg-11

Install packages

Install using meta-packageInstall packages individually

$ sudo yum install percona-ppg-server11

1. Install the PostgreSQL server package:

   $ sudo yum install percona-postgresql11-server
   

2. Install the components:

   Install pg_repack:

   $ sudo yum install percona-pg_repack11
   

   Install pgaudit:

   $ sudo yum install percona-pgaudit
   

   Install pgBackRest:

   $ sudo yum install percona-pgbackrest
   

   Install Patroni:

   $ sudo yum install percona-patroni
   

   Install pg_stat_monitor:

   Install pgBouncer:

   $ sudo yum install percona-pgbouncer
   

   Install pgAudit-set_user:

   $ sudo yum install percona-pgaudit11_set_user
   

   Install pgBadger:

   $ sudo yum install percona-pgbadger
   

   Install wal2json:

   $ sudo yum install percona-wal2json11
   

   Install PostgreSQL contrib extensions:

   $ sudo yum install percona-postgresql11-contrib
   

   Install HAProxy

   $ sudo yum install percona-haproxy
   

   Install pg_gather

   $ sudo yum install percona-pg_gather
   

   Install pgpool2

   To install pgpool2 on Red Hat Enterprise Linux and compatible derivatives, enable the codeready builder repository first to resolve dependencies conflict for pgpool2. The following examples show steps for Red Hat Enterprise Linux 9.

   RHEL 9CentOS 9Oracle Linux 9

   1. Enable the codeready builder repository

      $ sudo dnf config-manager --set-enabled codeready-builder-for-rhel-9-x86_64-rpms
      

   2. Install the extension

      $ sudo yum install percona-pgpool-II-pg11
      

   1. Enable the codeready builder repository

      $ sudo dnf config-manager --set-enabled crb
      

   2. Install the extension

      $ sudo yum install percona-pgpool-II-pg11
      

   1. Enable the codeready builder repository

      $ sudo dnf config-manager --set-enabled ol9_codeready_builder
      

   2. Install the extension

      $ sudo yum install percona-pgpool-II-pg11
      

   For Red Hat Enterprise Linux 8, replace the operating system version in the commands accordingly.

Some extensions require additional setup in order to use them with Percona Distribution for PostgreSQL. For more information, refer to Enabling extensions.

Start the service

After the installation, the default database storage is not automatically initialized. To complete the installation and start Percona Distribution for PostgreSQL, initialize the database using the following command:

/usr/pgsql-11/bin/postgresql-11-setup initdb

Start the PostgreSQL service:

$ sudo systemctl start postgresql-11

Connect to the PostgreSQL server

By default, postgres user and postgres database are created in PostgreSQL upon its installation and initialization. This allows you to connect to the database as the postgres user.

$ sudo su postgres

Open the PostgreSQL interactive terminal:

$ psql

Hint

You can connect to psql as the postgres user in one go:

$ sudo su - postgres -c psql

To exit the psql terminal, use the following command:

$ \q

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: August 31, 2023
Created: December 5, 2022