postgresql 9.6.13 + pgpool3.7.10 构建高可用postgres集群
os version: CentOS release 6.10 (Final)
ip | hostname |
---|---|
192.168.248.124 | db1 |
192.168.248.125 | db2 |
192.168.248.126 | pgpool1 |
192.168.248.127 | pgpool2 |
192.168.248.101 | VIP |
os version: CentOS release 6.10 (Final)
- 配置/etc/hosts
cat /etc/hosts
192.168.248.124 db01
192.168.248.125 db02
192.168.248.126 dbp1
192.168.248.127 dbp2
- 配置各server之间互信
- root用户互信
- postgres用户互信
postgresql:psql_install.sh
pgpool:pgpool_install.sh
在安装pgpool时,注意修改pgpool配置。master和slave相反
/etc/init.d/postgresql-9.6 start
/etc/init.d/pgpool-II-96 start
PGPASSWORD=1qaz2wsx psql -h 192.168.248.101 -U postgres -p 9999 -c 'show pool_nodes'
pcp_recovery_node -U postgres -h 192.168.248.101 -p 9898 -n 1