13.8.4. Migrating from a Managed Database to an Embedded Database

Procedure 13.5. Migrating to an Embedded Database

1. Stop the main services on the Satellite server.

   [root@satellite ~]# rhn-satellite stop
   

   Copy to Clipboard Toggle word wrap
2. Shut down the database on the Managed Database server.

   [root@manageddb ~]# db-control stop
   

   Copy to Clipboard Toggle word wrap
3. Remove the rhn-upgrade if it exists on your server:

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

   Copy to Clipboard Toggle word wrap
4. Use db-control to create a database backup on the Managed Database Server and copy that backup to the Satellite server.

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

   Copy to Clipboard Toggle word wrap
   The Managed Database server is now free for other purposes. All further actions take place on the Satellite server.
5. Mount the Red Hat Satellite installation ISO on the Satellite server and set and export the YUM0 variable with the Red Hat Satellite mount point value.

   [root@satellite ~]# mkdir /media/cdrom
   [root@satellite ~]# mount -o loop Red_Hat_Satellite_57.iso /media/cdrom
   [root@satellite ~]# export YUM0=/media/cdrom
   

   Copy to Clipboard Toggle word wrap
6. Enable the red-hat-satellite repository. If the red-hat-satellite repository definition is not present, install the satellite-repo package found in $YUM0/Satellite. After the red-hat-satellite repository is enabled, install the @satellite-database package group and disable the red-hat-satellite repository.

   [root@satellite ~]# yum install @satellite-database --enablerepo=red-hat-satellite
   

   Copy to Clipboard Toggle word wrap
7. Use db-control to restore the database backup.

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

   Copy to Clipboard Toggle word wrap
8. Edit the /etc/rhn/rhn.conf file to remove the db_port and db_host values.

   [root@satellite ~]# sed -i 's/db_host\s*=.*/db_host = /' /etc/rhn/rhn.conf
   [root@satellite ~]# sed -i 's/db_port\s*=.*/db_port = /' /etc/rhn/rhn.conf
   

   Copy to Clipboard Toggle word wrap
9. Add the postgresql92-postgresql service to the /etc/rhn/service-list file to ensure that it is started and stopped in parallel with Red Hat Satellite.

   [root@satellite ~]# echo "SERVICES=\"postgresql92-postgresql \$SERVICES\"" >> /etc/rhn/service-list
   

   Copy to Clipboard Toggle word wrap
10. Start the Red Hat Satellite services.

    [root@satellite ~]# rhn-satellite start
    

    Copy to Clipboard Toggle word wrap