13.8. Migrating the Database

Procedure 13.2. Migrating to a Managed Database

1. Shut down the Red Hat Satellite instance:

   [root@satellite ~]# rhn-satellite stop
   

2. Remove the rhn-upgrade if it exists on your server:

   [root@satellite ~]# yum remove rhn-upgrade
   

3. Use db-control to create a database backup

   [root@satellite ~]# mkdir ~/dbbackup
   [root@satellite ~]# db-control backup ~/dbbackup
   

4. Copy the database backup from the Satellite server to the Managed Database server.

   [root@satellite ~]# scp -r ~/dbbackup root@manageddb.example.com:~/.
   

5. Install the Managed Database using the Red Hat Satellite installation ISO. For full instructions, see Section 4.2.6, “Installing the Managed Database”.
6. After you have installed the Managed External Database, shut it down and back up the database configuration and access control files.

   [root@manageddb ~]# db-control stop
   [root@manageddb ~]# cp /opt/rh/postgresql92/root/var/lib/pgsql/data/postgresql.conf ~/dbbackup
   [root@manageddb ~]# cp /opt/rh/postgresql92/root/var/lib/pgsql/data/pg_hba.conf ~/dbbackup
   

   You need to backup these files because the migration process will erase them.
7. Use db-control to restore the database backup to the Managed Database server.

   [root@manageddb ~]# db-control restore ~/dbbackup
   

8. Restore the database configuration and access control files from backup to the Managed Database.

   [root@manageddb ~]# cp ~/dbbackup/postgresql.conf /opt/rh/postgresql92/root/var/lib/pgsql/data/postgresql.conf
   [root@manageddb ~]# cp ~/dbbackup/pg_hba.conf /opt/rh/postgresql92/root/var/lib/pgsql/data/pg_hba.conf
   

9. On the Satellite server, edit the /etc/rhn/rhn.conf file and change db_host to the domain name of the Managed Database and set the db_port to 5432. For example:

   db_host = manageddb.example.com
   db_port = 5432
   

10. Remove postgresql92-postgresql from the /etc/rhn/service-list file on the Satellite server.

    [root@satellite ~]# sed -i 's/postgresql92-postgresql //g' /etc/rhn/service-list
    

11. On the Managed Database, edit the /etc/rhn/rhn.conf file and change db_name, db_user, db_password to reflect the same values in /etc/rhn/rhn.conf on the Satellite server. For example:

    db_name = mydb
    db_user = mydbuser
    db_password = mydbpassword
    

12. Start the Managed Database instance using db-control.

    [root@manageddb ~]# db-control start
    

13. Remove the postgresql92-server and spacewalk-dobby packages from the Satellite server.

    [root@satellite ~]# yum remove postgresql92-server spacewalk-dobby
    

14. Restart Red Hat Satellite.

    [root@satellite ~]# rhn-satellite start