3.5. Installing PostgreSQL

You can install only the same version of PostgreSQL that is installed with the satellite-installer tool during an internal database installation. You can install PostgreSQL using Red Hat Enterprise Linux Server 7 repositories or from an external source, as long as the version is supported. Satellite supports PostgreSQL version 12.1.

Procedure

  1. To install PostgreSQL, enter the following command: 

    # yum install rh-postgresql12-postgresql-server \
rh-postgresql12-syspaths \
rh-postgresql12-postgresql-evr

  2. To initialize PostgreSQL, enter the following command: 

    # postgresql-setup initdb

  3. Edit the /var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf file: 

    # vi /var/opt/rh/rh-postgresql12/lib/pgsql/data/postgresql.conf

  4. Remove the # and edit to listen to inbound connections: 

    listen_addresses = '*'

  5. Edit the /var/opt/rh/rh-postgresql12/lib/pgsql/data/pg_hba.conf file: 

    # vi /var/opt/rh/rh-postgresql12/lib/pgsql/data/pg_hba.conf

  6. Add the following line to the file: 

      host  all   all   Satellite_ip/24   md5

  7. To start, and enable PostgreSQL service, enter the following commands: 

    # systemctl start postgresql
# systemctl enable postgresql

  8. Open the postgresql port on the external PostgreSQL server: 

    # firewall-cmd --add-service=postgresql
# firewall-cmd --runtime-to-permanent

  9. Switch to the postgres user and start the PostgreSQL client: 

    $ su - postgres -c psql

  10. Create two databases and dedicated roles, one for Satellite and one for Candlepin: 

    CREATE USER "foreman" WITH PASSWORD 'Foreman_Password';
CREATE USER "candlepin" WITH PASSWORD 'Candlepin_Password';
CREATE DATABASE foreman OWNER foreman;
CREATE DATABASE candlepin OWNER candlepin;

  11. Exit the postgres user: 

    # \q

  12. From Satellite Server, test that you can access the database. If the connection succeeds, the commands return 1. 

    # PGPASSWORD='Foreman_Password' psql -h postgres.example.com  -p 5432 -U foreman -d foreman -c "SELECT 1 as ping"
# PGPASSWORD='Candlepin_Password' psql -h postgres.example.com -p 5432 -U candlepin -d candlepin -c "SELECT 1 as ping"