PostgreSQL数据管理

381 words in this article. # PostgreSQL , pgsql/ a

备份全部数据:

#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 postgres singel > /root/singel.sql

恢复:

/usr/local/pgsql/bin/psql -U postgres dbname < /root/singel.sql



All rights are reserved and users must seek my permission before making any other use of material contained in this site.

Add comments

No comment yet.