使用dump+restore离线迁移的方法shi最快的，过程中使用压缩+并行导出导入。示例如下：
source_db_user=
source_db_ip=
source_db_port=
source_db_name=
source_db_password=
target_db_user=
target_db_ip=
target_db_port=
target_db_name=
target_db_password=
echo "begin dumping"
date
export PGPASSWORD=$source_db_password
pg_dump -U $source_db_user -h $source_db_ip -p $source_db_port $source_db_name -Fd -j 5 -f dumpdir
echo "done dumping"
date
echo "begin restoring"
date
export PGPASSWORD=$target_db_password
pg_restore -U $target_db_user -h $target_db_ip -p $target_db_port -d $target_db_name -j 5 dumpdir
echo "end restoring"
date
