pgpool-II is not following new master node post master fail over

From: soumitra bhandary <soumitra(dot)bhandary(at)hotmail(dot)com>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: pgpool-II is not following new master node post master fail over
Date: 2019-06-06 04:10:18
Message-ID: BMXPR01MB3799A4272155ABC66F20178BE0170@BMXPR01MB3799.INDPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-admin

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'

Browse pgadmin-support by date

  From Date Subject
Next Message Aditya Toshniwal 2019-06-06 04:52:39 Re: BUG #15831: pgadmin bug: add column and comment failure when you alter table
Previous Message richard coleman 2019-06-05 18:28:59 Re: pgAdmin4 4.8 Kubuntu issues

Browse pgsql-admin by date

  From Date Subject
Next Message soumik.bhattacharjee 2019-06-06 08:57:33 RE: ERROR:::::: could not rename temporary statistics file ...
Previous Message Ron 2019-06-05 19:53:51 Re: configure multiple repository path in pgbackrest