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'
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 |
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 |