dump:
sudo -u postgres -i
将dbname dump备份到backup_db文件
pg_dump dbname > backup_db
恢复
将backup_db文件放置在目录
/var/lib/postgresql
使用backup_db文件恢复数据库dbname
psql --set ON_ERROR_STOP=on dbname < backup_db
sudo -u postgres -i
将dbname dump备份到backup_db文件
pg_dump dbname > backup_db
将backup_db文件放置在目录
/var/lib/postgresql
使用backup_db文件恢复数据库dbname
psql --set ON_ERROR_STOP=on dbname < backup_db