以下是在Debian上进行PostgreSQL数据库迁移的常用技巧及工具:
pg_dump -U username -d source_db -F c -b -v -f backup.dumppg_restore -U username -d target_db -v backup.dumppg_dumpall -U username -f all_databases.sqlpsql -U username -f all_databases.sqlpg_dump -F c -Z 9 -f backup.dump.gzpg_restore -j 4 -d target_db backup.dumppostgresql.conf:启用wal_level = replica,设置archive_mode = on。pg_hba.conf允许复制连接。CREATE USER replicator WITH REPLICATION PASSWORD 'password'。pg_basebackup拉取数据:pg_basebackup -U replicator -D /data -Ft -z -P。LOAD DATABASE
FROM mysql://user:pass@host/source_db
INTO postgresql://user:pass@host/target_db
WITH include drop, create tables, reset sequences
执行:pgloader migration.load。pg_dump的-Fc格式可保证一致性)。pg_checksums验证数据完整性,删除临时文件。参考来源: