[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