Backup
约 1 分钟阅读
标签：备份
- 导出
COPY ... TO STDOUT WITH CSV HEADER \g export.scv\copy (select 1 as val) TO 'test.csv' WITH CSV HEADER
- 参考
# -Z compress
pg_dump -Fc -Z 9 -j $(nproc) --file=file.dump myDb
pg_restore -Fc -j $(nproc) file.dump关联信息
反向链接、本文链接的其他页面和外部资料。
参考资料
其他外链4 条
- www.percona.com/blog/2019/03/27/postgresql-upgrade-using-pg_dump-pg_restorewww.percona.com/blog/2019/03/27/postgresql-upgrade-using-pg_dump-pg_restore
- www.postgresql.org/docs/current/app-pg-dumpall.htmlwww.postgresql.org/docs/current/app-pg-dumpall.html
- www.postgresql.org/docs/current/app-pgdump.htmlwww.postgresql.org/docs/current/app-pgdump.html
- www.postgresql.org/docs/current/app-pgrestore.htmlwww.postgresql.org/docs/current/app-pgrestore.html