Skip to content
logo
Percona Product Documentation
Install on RHEL and derivatives
Initializing search
    percona/postgresql-docs
    percona/postgresql-docs
    • Percona Distribution for PostgreSQL 11 Documentation
        • Overview
        • Install on Debian and Ubuntu
        • Install on RHEL and derivatives
          • Platform Specific Notes
          • Procedure
            • Configure the repository
            • Install packages
            • Start the service
            • Connect to the PostgreSQL server
        • Enable Percona Distribution for PostgreSQL extensions
        • Repositories overview
      • Migrate from PostgreSQL to Percona Distribution for PostgreSQL
      • Minor Upgrade of Percona Distribution for PostgreSQL
      • pg_stat_monitor
      • High availability
        • Deploying on Debian or Ubuntu
        • Deploying on RHEL or CentOS
        • Testing the Patroni PostgreSQL Cluster
      • Backup and disaster recovery
        • Deploying backup and disaster recovery solution in Percona Distribution for PostgreSQL
      • LDAP authentication
    • Uninstall
      • Release notes index
      • Percona Distribution for PostgreSQL 11.18 (2022-12-08)
      • Percona Distribution for PostgreSQL 11.17 (2022-09-08)
      • Percona Distribution for PostgreSQL 11.16 (2022-06-07)
      • Percona Distribution for PostgreSQL 11.15 Second Update (2022-05-05)
      • Percona Distribution for PostgreSQL 11.15 Update (2022-04-14)
      • Percona Distribution for PostgreSQL 11.15 (2022-04-08)
      • Percona Distribution for PostgreSQL 11.14 (2021-12-20)
      • Percona Distribution for PostgreSQL 11.13 Update (2021-12-07)
      • Percona Distribution for PostgreSQL 11.13 (2021-09-09)
      • Percona Distribution for PostgreSQL 11.12 Third Update (2021-07-15)
      • Percona Distribution for PostgreSQL 11.12 Second Update (2021-07-01)
      • Percona Distribution for PostgreSQL 11.12 Update (2021-06-10)
      • Percona Distribution for PostgreSQL 11.12 (2021-05-24)
      • Percona Distribution for PostgreSQL 11.11 Third Update (2021-06-10)
      • Percona Distribution for PostgreSQL 11.11 Second Update (2021-05-10)
      • Percona Distribution for PostgreSQL 11.11 Update (2021-04-12)
      • Percona Distribution for PostgreSQL 11.11 (2021-03-08)
      • Percona Distribution for PostgreSQL 11.10 Update (2021-06-10)
      • Percona Distribution for PostgreSQL 11.10 (2020-12-15)
      • Percona Distribution for PostgreSQL 11.9 (2020-09-08)
      • Percona Distribution for PostgreSQL 11.8 (2020-06-11)
      • Percona Distribution for PostgreSQL 11.7 (2020-04-09)
      • Percona Distribution for PostgreSQL 11.6 (2020-01-23)
      • Percona Distribution for PostgreSQL 11 (2019-09-17)
      • Percona Distribution for PostgreSQL 11 (Beta) (2019-05-15)
    • Licensing
    • Platform Specific Notes
    • Procedure
      • Configure the repository
      • Install packages
      • Start the service
      • Connect to the PostgreSQL server

    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¶

    $ 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
      

      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 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: March 29, 2023
    Created: December 5, 2022
    Percona LLC, © 2022
    Made with Material for MkDocs

    Cookie consent

    We use cookies to recognize your repeated visits and preferences, as well as to measure the effectiveness of our documentation and whether users find what they're searching for. With your consent, you're helping us to make our documentation better.