4.3. 迁移到外部数据库
备份和传输现有数据,然后使用 satellite-installer
命令将 Satellite 配置为连接到外部 PostgreSQL 数据库服务器。
先决条件
- 您已在 Red Hat Enterprise Linux 服务器中安装和配置了 PostgreSQL 服务器。
流程
在 Satellite 服务器上,停止除 PostgreSQL 的所有 Satellite 服务:
satellite-maintain service stop --exclude postgresql
# satellite-maintain service stop --exclude postgresql
Copy to Clipboard Copied! Toggle word wrap Toggle overflow 为 Satellite 备份创建目标目录:
mkdir /var/My_Migration_Backup_Directory
# mkdir /var/My_Migration_Backup_Directory
Copy to Clipboard Copied! Toggle word wrap Toggle overflow 备份内部数据库:
satellite-maintain backup online \ --preserve-directory \ --skip-pulp-content \ /var/My_Migration_Backup_Directory
# satellite-maintain backup online \ --preserve-directory \ --skip-pulp-content \ /var/My_Migration_Backup_Directory
Copy to Clipboard Copied! Toggle word wrap Toggle overflow 将数据传送到新的外部数据库:
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
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 Copied! Toggle word wrap Toggle overflow 使用
satellite-installer
命令更新 Satellite 以指向新数据库:Copy to Clipboard Copied! Toggle word wrap Toggle overflow 删除 Satellite 服务器上的 PostgreSQL 软件包:
satellite-maintain packages remove postgresql-server
# satellite-maintain packages remove postgresql-server
Copy to Clipboard Copied! Toggle word wrap Toggle overflow 删除 PostgreSQL 数据目录:
rm -fr /var/lib/pgsql/data
# rm -fr /var/lib/pgsql/data
Copy to Clipboard Copied! Toggle word wrap Toggle overflow