个人技术分享

基础备份

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