From: soumitra bhandary <soumitra.bhandary@hotmail.com>
To: pgadmin-support@lists.postgresql.org <pgadmin-support@lists.postgresql.org>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: pgpool-II is not following new master node post master fail over
Date: Thu, 6 Jun 2019 04:10:18 +0000
Message-ID: <BMXPR01MB3799A4272155ABC66F20178BE0170@BMXPR01MB3799.INDPRD01.PROD.OUTLOOK.COM> (raw)
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'
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: soumitra.bhandary@hotmail.com, pgadmin-support@lists.postgresql.org
Subject: Re: pgpool-II is not following new master node post master fail over
In-Reply-To: <BMXPR01MB3799A4272155ABC66F20178BE0170@BMXPR01MB3799.INDPRD01.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox