hhdb10.4——增量备份

vim /home/hh/hhdb/data/hhdbsql.conf  
#文件末尾添加
wal_level=replica
archive_mode=on
archive_command = 'test ! -f /home/hh/hhdb/arch/%f && cp %p /home/hh/hhdb/arch/%f'

cd /home/hh/hhdb/bin
  ./start start_db_bg.sh
  ./runsql.sh  #输入帐号和密码登录数据库

create table lhx_test(id int,name varchar(20),time timestamp with time zone);
insert into lhx_test(id,name,time)values(1,'关羽',now());

hhdb=# select hh_start_backup('basebak');
 hh_start_backup 
-----------------
 0/8000060
(1 行记录)

备份data目录
cd /home/hh/hhdb
tar czvf hhdata.tar.gz data

hhdb=# select hh_stop_backup();
注意:  hh_stop_backup 执行完成，所有需要的WAL段都已经归档完成。
 hh_stop_backup 
----------------
 0/8000168
(1 行记录)

hhdb=# insert into lhx_test(id,name,time)values(2,'张飞',now());
INSERT 0 1
hhdb=# select hh_switch_wal();
 hh_switch_wal 
---------------
 0/C000270
(1 行记录)

hhdb=# insert into lhx_test(id,name,time)values(3,'赵云',now());
INSERT 0 1
hhdb=# select hh_switch_wal();
 hh_switch_wal 
---------------
 0/100000F0
(1 行记录)

hhdb=# insert into lhx_test(id,name,time)values(4,'黄忠',now());
INSERT 0 1
hhdb=# select hh_switch_wal();
 hh_switch_wal 
---------------
 0/140000F0
(1 行记录)

[hh@localhost hhdb]$ cd bin
[hh@localhost bin]$ ./stop_db.sh 
等待服务器进程关闭 .... 完成
服务器进程已经关闭

cd /home/hh/hhdb 
mv data data1
tar xzvf hhdata.tar.gz

#在新的data目录下创建recovery.conf文件。可以从模版复制过来
cd /home/hh/hhdb/data
cp ../share/hhdbsql/recovery.conf.sample recovery.conf
vi recovery.conf
文件末尾添加
restore_command='cp /home/hh/hhdb/arch/%f "%p"'

#启动数据库
cd /home/hh/hhdb/bin
./start_db_bg.sh

hhdb=# table lhx_test ;
 id | name |             time              
----+------+-------------------------------
  1 | 关羽 | 2021-11-30 10:19:23.926888+08
  2 | 张飞 | 2021-11-30 10:21:51.025001+08
  3 | 赵云 | 2021-11-30 10:22:21.806225+08
  4 | 黄忠 | 2021-11-30 10:23:19.350576+08
(4 行记录)

hhdb=#