postgresql 12 配置异步主从复制 及灾难时切换

OS: Centos 8, postgresql12

主机: host1, ip : 128.30.14.254

从机: host2, ip: 128.30.14.255

两台机的data目录均为/live/db/data

• 在host1上进行如下配置

1. 打通主机机ip授权:

   
   # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
   host    replication     replica      128.30.14.254/32       trust
   host    replication     replica      128.30.14.255/32       trust
   

    

2. 修改postgres.conf

wal_level = replica 
wal_keep_segments = 100
full_page_writes = on
wal_log_hints = on

1. 建立用于复制的帐号

   postgres=# create user replica replication login connection limit 5 encrypted password 'password' ;
   

    

2. 重启pg , systemctl restart postgresql

• 在host2上进行配置

1. 用postgres帐号运行pg_basebackup -h 128.30.14.254 -p 5432 -U replica -Fp -Xs -Pv -R -D /live/db/data

   [root@pg12-test-2 db]# pg_basebackup -h 128.