1.数据库备份与恢复
数据库备份
pg_dump -h localhost -U postgres -d mapdb > D:\possql\data\mapdb.bak
数据库恢复
psql -h localhost -U postgres -d testdb < D:\possql\data\mapdb.bak
2.表备份与恢复
表备份
pg_dump -h localhost -U postgres -d mapdb -t climate > D:\possql\data\climate.bak
表恢复
psql -h localhost -U postgres -d testdb -t climate < D:\possql\data\climate.bak