一、postgresql流复制
实例: 1 MASTER
2 SLAVE
(一)Master
- 安装Master
依次安装rpm包:
rpm -ivh postgresql11-libs-11.7-1PGDG.rhel6.x86_64.rpm
rpm -ivh postgresql11-11.7-1PGDG.rhel6.x86_64.rpm
rpm -ivh postgresql11-server-11.7-1PGDG.rhel6.x86_64.rpm
rpm -ivh postgresql11-contrib-11.7-1PGDG.rhel6.x86_64.rpm
rpm -ivh postgresql11-devel-11.7-1PGDG.rhel6.x86_64.rpm - 主库初始化service postgresql-11 initdb
- 创建用户repuser,并赋予复制和登录的权限
CREATE USER repuser LOGIN REPLICATION ENCRYPTED PASSWORD ‘repuser’; - 修改postgresql.conf
listen_addresses = ‘*’
wal_log_hints = on
wal_level = hot_standby
max_wal_senders = 5
archive_mode = on
archive_command = ‘cp %p /var/lib/pgsql/11/data/pg_archive/%f’
wal_keep_segments = 64
synchronous_standby_names = ‘cbas_standby_[host1],cbas_standby_[host2]’ - 创建归档目录mkdir /var/lib/p