【postgres】单机热备方案

建立存储存储基础备份的目录，
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.youkuaiyun.com/luojinbai/article/details/43670057