备份:cd D:\PostgreSQL\9.0\bin\ 切换到pg数据库的bin目录
pg_dump.exe -h localhost -p 5432 -U postgres “databasename” > databasename.bak
恢复:cd D:\PostgreSQL\9.0\bin\ 切换到pg数据库的bin目录
psql -h localhost -p port -U postgres -d databasename < databasename.bak
备份:cd D:\PostgreSQL\9.0\bin\ 切换到pg数据库的bin目录
pg_dump.exe -h localhost -p 5432 -U postgres “databasename” > databasename.bak
恢复:cd D:\PostgreSQL\9.0\bin\ 切换到pg数据库的bin目录
psql -h localhost -p port -U postgres -d databasename < databasename.bak