postgresql 数据库备份与恢复

备份：

pg_dump –h localhost –U username –b db_name > dump_file

恢复：

dropdb –h localhost –U username db_name

createdb –h localhost –U username db_name

psql –h localhost –U username –d db_name < dump_file