执行步骤：
- 备份数据库
[postgres@test ~]$ /usr/pgsql-9.6/bin/pg_dump pp100_loanapply | /bin/gzip > loanapply_$(date +%F).sql.gz
2.创建数据库并授权
create database db_name owner user_name;
3.将备份的文件上传到新pg服务器上
gzip -dv loanapply_2018-03-22.sql.gz
4.修改备份文件的内容
sed -i "/osdba/d" loanapply_2018-03-22.sql
sed -i "/SET idle_in_transaction_session_timeout = 0;/d" loanapply_2018-03-22.sql
sed -i "/SET row_security = off;/d" loanapply_2018-03-22.sql
sed -i '/plpgsql/d' loanapply_2018-03-22.sql
sed -i "/pgpool_/d" loanapply_2018-03-22.sql
5.导入数据
psql -h 192.168.1.10 -p 3433 -Udba_user -W loanapply < loanapply_2018-03-22.sql
