关于PostgreSQL的备份和恢复详细信息请参阅《PostgreSQL中文文档》。
备份:
#pg_dump --username=postgres v70_demo > v70_demo_20130704.dump
恢复:
#createdb --username=postgres v70_demo_temp
#psql --username=postgres v70_demo_temp < v70_demo_20130704.dump
#dropdb --username=postgres v70_demo_temp