postgresql 数据库备份和恢复
1、备份
pg_dump -h hostip -U postgres databasename > C:\databasename.bak
2、恢复
psql -h hostip -U postgres -d databasename < C:\databasename.bak
1、备份
pg_dump -h hostip -U postgres databasename > C:\databasename.bak
2、恢复
psql -h hostip -U postgres -d databasename < C:\databasename.bak