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