逻辑导出:
pg_dump -d test > /tmp/test.sql
导入:psql < /tmp/test.sql
pg_dumpall > /tmp/alldbs.sql
物理备份:
pg_basebackup -D /pgdata/pg_backup -Ft -Pv -Upostgres -h 192.168.10.1 -p 5432 -R
恢复:
vi postgresql.auto.conf
restore_command='cp /archive/%f %p'
recover_target='immediate'
touch /pgdata/12/data/recovery.signal
select pg_wal_replay_resume();
pirt恢复:
vi postgresql.auto.conf
restore_command='cp /archive/%f %p'
recover_target_xid='566'