kingbase V8R3 两个单机搭建流复制

两个单机搭建流复制
1、主机data/kingbase.conf添加：

wal_level = replica # minimal, replica, or logical
max_wal_senders = 10 # max number of walsender processes
wal_keep_segments = 512 # in logfile segments, 16MB each; 0 disables
max_replication_slots = 4
hot_standby = on
synchronous_standby_names='1(node2)'

2、主机修改sys_hba.conf文件
去掉最后注释，加上以下一行

host    replication     SYSTEM        备机IP/32            md5

3、备机拉取数据

sys_basebackup -U SYSTEM -h 主机IP -D /home/kingbase/cluster/KingbaseCluster/db/data -X stream -v -P 

4、备机从template拷贝recovery.conf到data下，修改，内容如下

standby_mode='on'
primary_conninfo='port=54321 host=主机IP user=SYSTEM password=MTIzNDU2Cg==(base64加密后的密码(echo 密码 | base64)) application_name=node2'
recovery_target_timeline='latest'

5、主机创建复制槽

select sys_create_physical_replication_slot('slot_node1');
select sys_create_physical_replication_slot('slot_node2');