[pgpool-general: 3755] Pgpool and repmgr failover configuration
Ferdous Shibly
bdshibly at gmail.com
Wed May 27 09:18:24 JST 2015
Hi,
I am trying to configure PostgreSQL streaming replication with repmgr
and pgpool in my test environment. Here is the node information
pgpool node1: 192.168.56.11
pgpool node2: 192/168.56.12
repmgr node1: 192/168.56.13
repmgr node2: 192/168.56.14
I enabled watchdog in pgpool and the dedicated IP is 192/168.56.10.
I enabled autofailover in repmgr which is working properly but having
problem in fail back. Like, let's say, pgpool node1 has the virtual
interface and repmgr node1 is master and repmgr node 2 is standby.
when I kill postgresql process in repmgr node 1, repmgr node2 is
promoted automatically and I can perform both read and write operation
through the dedicated IP of pgpool. But when I restore repmgr node2 as
standby, I can only perform read. How can I resolve this problem?
Regarding with
Ferdous Shibly
More information about the pgpool-general
mailing list