关于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