i东风-记录与评论 PostgreSQL数据管理
备份全部数据：#cd /usr/local/pgsql/bin /usr/local/pgsql/bin/pg_dumpall -U postgres > /root/pgall.sql 恢复全部数据：/usr/local/pgsql/bin/psql -U postgres -f /root/pgall.sql 备份单个数据库/usr/local/pgsql/bin/pg_dump -U
备份全部数据：#cd /usr/local/pgsql/bin /usr/local/pgsql/bin/pg_dumpall -U postgres > /root/pgall.sql 恢复全部数据：/usr/local/pgsql/bin/psql -U postgres -f /root/pgall.sql 备份单个数据库/usr/local/pgsql/bin/pg_dump -U