合 PG常见高可用方案

主备流复制：

• PG12高可用之1主2从流复制环境搭建及切换测试：https://www.dbaup.com/dbbao60pg12gaokeyongzhi1zhu2congliufuzhihuanjingdajianjiqiehuanceshi.html
• PG 14 + Pgpool-II + Watchdog 实现高可用（自动故障转移+读写分离+负载均衡）：https://www.dbaup.com/pg-14-pgpool-ii-watchdog-shixiangaokeyongzidongguzhangzhuanyiduxiefenlifuzaijunheng.html
• pgpool-II和pgpoolAdmin的使用：https://www.dbaup.com/dbbao72pgpool-iihepgpooladmindeshiyong.html
• PostgreSQL使用Pgpool-II实现读写分离+负载均衡：https://www.dbaup.com/dbbao61postgresqlshiyongpgpool-iishixianduxiefenlifuzaijunheng.html
• PostgreSQL高可用之repmgr（1主2从+1witness）+Pgpool-II实现主从切换+读写分离+负载均衡：https://www.dbaup.com/dbbao62postgresqlgaokeyongzhirepmgr1zhu2cong1witnesspgpool-iishixianzhucongqiehuan.html
• PG高可用集群之Patroni + etcd + HAProxy + keepalived + Prometheus + Grafana监控 部署：https://www.dbaup.com/pggaokeyongjiqunzhipatroni-etcd-haproxy-keepalived-prometheus-grafanajiankong-bushu.html
• PostgreSQL 11版本基于Pacemaker+Corosync+pcs的高可用搭建：https://www.dbaup.com/postgresql-11banbenjiyupacemakercorosyncpcsdegaokeyongdajian.html
• PG高可用之主从流复制+keepalived 的高可用：https://www.dbaup.com/pggaokeyongzhizhucongliufuzhikeepalived-degaokeyong.html

常见分布式方案：

• PG高可用之Citus分布式集群搭建及使用：https://www.dbaup.com/pggaokeyongzhicitusfenbushijiqundajianjishiyong.html
• PG分布式之PGXL安装部署：https://www.dbaup.com/pgfenbushizhipgxlanzhuangbushu.html
• PG分布式之Greenplum安装配置：https://www.dbaup.com/greenplumanzhuangpeizhi.html

双主方案：

• 使用使用Bucardo搭建PG的双主：参考：https://www.dbaup.com/shiyongbucardodajianpgdeshuangzhu.html
• 使用OGG for PG微服务快速双向同步RDS数据库（双主）：https://www.dbaup.com/shiyongogg-for-pgweifuwukuaisushuangxiangtongburdsshujukushuangzhu.html
• OGG用于PG数据库之间双主实时同步（RDS for PG亦可）–OGG远程捕获和投递：https://www.dbaup.com/oggyongyupgshujukuzhijianshuangzhushishitongburds-for-pgyikeoggyuanchengbuhuohetoudi.html