基础备份
pg_basebackup -D /home/postgres/pg_testdb_backup -Ft -Xs -z -Z 5 -P -v -h 127.0.0.1 -p 5432 -U postgres -w
恢复:
cd /home/postgres/pg_testdb_backup
解压备份
tar -xf base.tar.gz
tar -xf pg_wal.tar.gz -C pg_wal/
恢复设置,恢复到最新
touch recovery.signal
vi postgresql.conf
restore_command = 'cp /home/postgres/pg_testdb/arch/%f %p'
##/home/postgres/pg_testdb/arch 是归档的wal文件
启动完成
pg_ctl start -D /home/postgres/pg_testdb_backup