Postgresql备份还原

1.备份

PostgreSQL\9.2\bin>pg_dump.exe -D -h localhost -U userName dbName > D:\\db.bak

2.还原

PostgreSQL\9.2\bin>psql -h localhost -U userName -d dbName < D:\\db.bak

转载于:https://www.cnblogs.com/xufeiyang/articles/3387403.html