1 准备工作
1.1 PG版本
psql (PostgreSQL) 10.8
1.2 系统准备
安装工具
调整时区
安装POSTGRES数据库
配置主从服务器的postgres用户相互免密SSH登录
2 主库服务器操作
2.1 修改pg_hba.conf文件
host replication replicator 主库IP/32 md5
host replication replicator 从库IP/32 md5
host all all all md5
2.2 修改主库的配置文件postgresql.conf
wal_level = replica
max_wal_senders = 6
wal_keep_segments = 1024
wal_sender_timeout = 60s
max_connections = 1000
wal_log_hints = on
full_page_writes = on
2.3 创建Replication用户
create role replicator login replication password '123456';
2.4 启动主库
pg_ctl -D /usr/local/pgsql/datas/demo -l /usr/local/pgsql/datas/demo/logdemo.log start
3 从库操作
3.1 在从库获取主库的基础备份
pg_basebackup -h 10.37.129.5 -p 5432 -U replicator -F p -P -D /usr/local/pgsql/datas/demo
3.2 修改从库的配置文件
listen_addresses = '*'
wal_level = hot_standby
max_connections = 2000
hot_standby = on
max_standby_streaming_delay = 30s
wal_receiver_status_interval = 10s
hot_standby_feedback = on
wal_log_hints = on
full_page_writes = on
3.3 配置从库恢复文件
cp /usr/local/pgsql/share/recovery.conf.sample /usr/local/pgsql/datas/demo/recovery.conf
standby_mode = 'on'
primary_conninfo = 'host=10.211.55.61 port=5432 user=replicator password=123456'
recovery_target_timeline = 'latest'
3.4 启动从库
pg_ctl -D /usr/local/pgsql/datas/demo -l /usr/local/pgsql/datas/demo/logdemo.log start