Hi ,
I am using repmgr to manage the auto fail over process at PostgreSQL Database layer in a 3 node master - slave replication .
Also using pgpool-II to manage the load balancing and application connection routing.
But when any master failover is happening at DB side and new master is promoted using repmgr pgpool-II is not connecting to new master and still trying to connect old master node.
Here is my pgpool-II conf file parameters . Am I missing anything ?
backend_hostname0 = 'server1'
# Host name or IP address to connect to for backend 0
backend_port0 = 5432
# Port number for backend 0
backend_weight0 = 1
# Weight for backend 0 (only in load balancing mode)
backend_data_directory0 = '/data/pgdata/10/data'
# Data directory for backend 0
backend_flag0 = 'ALLOW_TO_FAILOVER'
# Controls various backend behavior
# ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER
backend_hostname1 = 'server2'
backend_port1 = 5432
backend_weight1 = 10
backend_data_directory1 = '/data/pgdata/10/data'
backend_flag1 = 'ALLOW_TO_FAILOVER'
backend_hostname2 = 'server3'
backend_port2 = 5432
backend_weight2 = 10
backend_data_directory2 = '/data/pgdata/10/data'
backend_flag2 = 'ALLOW_TO_FAILOVER'