PostgreSQL 备份pg_dump与还原pg_restore；pg_dump -h localhost -p 5432 -U postgres -W -F c -b -v -f

pg_dump -h localhost -p 5432 -U postgres -W -F c -b -v -f

pg_restore -h localhost -U postgres -W -d password

PostgreSQL 备份pg_dump与还原pg_restore

备份还原方法：pg_dump和pg_restore

远程复制scp：

　　/usr/bin/scp

　　#rpm -qf /usr/bin/scp

　　/openssh-client.xxxx

　　# ssh -p 端口  pole-an@localhost.local

　　# scp -v -P 端口  /home/pole-an/pole-an-pgdb.tar  pole-an@localhost.local:/home/pole-an/

数据备份pg_dump与还原pg_restore：

　 备份：
　 pg_dump -h localhost