13.8.4. Migrating from a Managed Database to an Embedded Database
The requirements to migrate from Managed to Embedded Database are:
- The Red Hat Satellite installation ISO
- A complete installation of Red Hat Satellite server (
satellite.example.com
) with a Managed Database on a seperate server (manageddb.example.com
)
Procedure 13.5. Migrating to an Embedded Database
- Stop the main services on the Satellite server.
[root@satellite ~]# rhn-satellite stop
- Shut down the database on the Managed Database server.
[root@manageddb ~]# db-control stop
- Remove the
rhn-upgrade
if it exists on your server:[root@satellite ~]# yum remove rhn-upgrade
- 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:~/.
The Managed Database server is now free for other purposes. All further actions take place on the Satellite server. - 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
- Enable the
red-hat-satellite
repository. If thered-hat-satellite
repository definition is not present, install thesatellite-repo
package found in$YUM0/Satellite
. After thered-hat-satellite
repository is enabled, install the@satellite-database
package group and disable thered-hat-satellite
repository.[root@satellite ~]# yum install @satellite-database --enablerepo=red-hat-satellite
- Use
db-control
to restore the database backup.[root@satellite ~]# db-control restore ~/dbbackup
- 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
- 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
- Start the Red Hat Satellite services.
[root@satellite ~]# rhn-satellite start
The database is now migrated from a Managed Database to an Embedded Database.