proc_migrating-to-external-databases.adoc

Migrating to External Databases

Back up and transfer existing data, then use the {foreman-installer} command to configure {Project} to connect to an external PostgreSQL database server.

Prerequisite

• You have installed and configured a PostgreSQL server on a {EL} server.

Procedure

1. On {ProjectServer}, stop {Project} services:

   # {foreman-maintain} service stop

2. Start the PostgreSQL services:

   # systemctl start postgresql

3. Back up the internal databases:

   # {foreman-maintain} backup online \
   --preserve-directory \
   --skip-pulp-content \
   /var/migration_backup

4. Transfer the data to the new external databases:

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

5. Use the {foreman-installer} command to update {Project} to point to the new databases:

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