Chapter 4. Migrating from internal Satellite databases to external databases

Procedure

1. On your new database server, install PostgreSQL:

   # dnf install postgresql-server postgresql-contrib

2. Initialize the PostgreSQL database:

   # postgresql-setup --initdb

3. Edit the /var/lib/pgsql/data/postgresql.conf file:

   # vi /var/lib/pgsql/data/postgresql.conf

   Note that the default configuration of external PostgreSQL needs to be adjusted to work with Satellite. The base recommended external database configuration adjustments are as follows:

   • checkpoint_completion_target: 0.9
   • max_connections: 500
   • shared_buffers: 512MB
   • work_mem: 4MB

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

   listen_addresses = '*'

5. Add the following line to the end of the file to use SCRAM for authentication:

   password_encryption=scram-sha-256

6. Edit the /var/lib/pgsql/data/pg_hba.conf file:

   # vi /var/lib/pgsql/data/pg_hba.conf

7. Add the following line to the file:

     host  all   all   Satellite_ip/32   scram-sha-256

8. Start and enable the PostgreSQL service:

   # systemctl enable --now postgresql

9. Open the postgresql port:

   # firewall-cmd --add-service=postgresql

10. Make the changes persistent:

    # firewall-cmd --runtime-to-permanent

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

    $ su - postgres -c psql

12. Create three databases and dedicated roles: one for Foreman, one for Candlepin, and one for Pulp:

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

13. Exit the postgres user:

    # \q

14. 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"
    # PGPASSWORD='Pulpcore_Password' psql -h postgres.example.com -p 5432 -U pulp -d pulpcore -c "SELECT 1 as ping"

Procedure

1. On Satellite Server, stop all Satellite services except for PostgreSQL:

   # satellite-maintain service stop --exclude postgresql

2. Create your target directory for the Satellite backup:

   # mkdir /var/My_Migration_Backup_Directory

3. Back up the internal databases:

   # satellite-maintain backup online \
   --preserve-directory \
   --skip-pulp-content \
   /var/My_Migration_Backup_Directory

4. Transfer the data to the new external databases:

   PGPASSWORD='Foreman_Password' pg_restore -h postgres.example.com -U foreman -d foreman < /var/My_Migration_Backup_Directory/foreman.dump
   PGPASSWORD='Candlepin_Password' pg_restore -h postgres.example.com -U candlepin -d candlepin < /var/My_Migration_Backup_Directory/candlepin.dump
   PGPASSWORD='Pulpcore_Password' pg_restore -h postgres.example.com -U pulp -d pulpcore < /var/My_Migration_Backup_Directory/pulpcore.dump

5. Use the satellite-installer command to update Satellite to point to the new databases:

   # satellite-installer \
   --katello-candlepin-manage-db false \
   --katello-candlepin-db-host postgres.example.com \
   --katello-candlepin-db-name candlepin \
   --katello-candlepin-db-user candlepin \
   --katello-candlepin-db-password Candlepin_Password \
   --foreman-proxy-content-pulpcore-manage-postgresql false \
   --foreman-proxy-content-pulpcore-postgresql-host postgres.example.com \
   --foreman-proxy-content-pulpcore-postgresql-db-name pulpcore \
   --foreman-proxy-content-pulpcore-postgresql-user pulp \
   --foreman-proxy-content-pulpcore-postgresql-password Pulpcore_Password \
   --foreman-db-manage false \
   --foreman-db-host postgres.example.com \
   --foreman-db-database foreman \
   --foreman-db-username foreman \
   --foreman-db-password Foreman_Password

6. Remove the PostgreSQL package on Satellite Server:

   # satellite-maintain packages remove postgresql-server

7. Remove the PostgreSQL data directory:

   # rm -fr /var/lib/pgsql/data