建立存储存储基础备份的目录,
mkdir /home/postgres/archive
mkdir /home/postgres/base
修改
wal_level = archive
archive_mode = on
archive_command = 'cp %p /home/postgres/archive/%f'
重启
1. 创建表,插入20测试数据:
create table foo(id integer);
insert into foo values(generate_series(1,10));
做一次基础备份:
②、执行 pg_basebackup -Ft -Pv -Xf -z -Z5 -D /home/postgres/base
查看base文件
执行 select pg_switch_wal();
查看wal文件
------------------
往表中再插入10条数据,使得总数据为20:
insert into foo values(generate_series(1,10));
关闭数据库
mv /var/lib/pgsql/11/data /var/lib/pgsql/11/data.bak
mkdir /var/lib/pgsql/11/data
cd /var/lib/pgsql/11/data
mv /home/postgres/base/base.tar.gz /var/lib/pgsql/11/data
tar -zxvf base.tar.gz
rm -rf pg_wal
mkdir -p pg_wal/archive_status
rm -rf postmaster.pid
cp /usr/pgsql-11/share/recovery.conf.sample recovery.conf
vi recovery.conf
restore_command = 'cp /home/postgres/archive/%f %p'
重启https://blog.csdn.net/luojinbai/article/details/43670057