合 PG高可用集群之Patroni + etcd + HAProxy + keepalived + Prometheus + Grafana监控 部署
Tags: PG高可用GrafanaPrometheuskeepalivedPatroniHAProxyetcd
搭建1主2从的流复制环境
详细搭建过程可以参考:PG12高可用之1主2从流复制环境搭建及切换测试:https://www.dbaup.com/dbbao60pg12gaokeyongzhi1zhu2congliufuzhihuanjingdajianjiqiehuanceshi.html
主库操作
配置主库pg_hba.conf
1 2 3 4 5 6 7 8 | cat << EOF > /var/lib/pgsql/13/data/pg_hba.conf # TYPE DATABASE USER ADDRESS METHOD local all all trust host all all 127.0.0.1/32 trust host all all 0.0.0.0/0 md5 host replication all 0.0.0.0/0 md5 EOF |
配置主库参数
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | -- 登陆主库环境 docker exec -it lhrpgpatroni71 bash -- 该路径也需要在从库创建 mkdir -p /postgresql/archive chown -R postgres.postgres /postgresql/archive -- 修改参数 cat >> /var/lib/pgsql/13/data/postgresql.conf <<"EOF" wal_level='replica' archive_mode='on' archive_command='test ! -f /postgresql/archive/%f && cp %p /postgresql/archive/%f' max_wal_senders=10 EOF -- 重启 systemctl restart postgresql-13.service -- 查询参数 select * from pg_settings where name in ('wal_level','archive_mode','archive_command'); |
笔耕不辍,我辈学习楷模。