Backup

• 导出
  • COPY ... TO STDOUT WITH CSV HEADER \g export.scv
  • \copy (select 1 as val) TO 'test.csv' WITH CSV HEADER
• 参考
  • pg_dumpall
  • pg_dump
  • pg_restore
  • https://www.percona.com/blog/2019/03/27/postgresql-upgrade-using-pg_dump-pg_restore/

# -Z compress
pg_dump -Fc -Z 9 -j $(nproc) --file=file.dump myDb
pg_restore -Fc -j $(nproc) file.dump