4.4. 迁移到外部数据库

流程

1. 在 Satellite 服务器上，停止除 PostgreSQL 的所有 Satellite 服务：

   # satellite-maintain service stop --exclude postgresql

   Copy to Clipboard Toggle word wrap

2. 为 Satellite 备份创建目标目录：

   # mkdir /var/My_Migration_Backup_Directory

   Copy to Clipboard Toggle word wrap

3. 备份内部数据库：

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

   Copy to Clipboard Toggle word wrap

4. 将数据传送到新的外部数据库：

   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

   Copy to Clipboard Toggle word wrap

5. 使用 satellite-installer 命令更新 Satellite 以指向新数据库：

   # 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

   Copy to Clipboard Toggle word wrap

6. 删除 Satellite 服务器上的 PostgreSQL 软件包：

   # satellite-maintain packages remove postgresql-server

   Copy to Clipboard Toggle word wrap

7. 删除 PostgreSQL 数据目录：

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

   Copy to Clipboard Toggle word wrap