[pgpool-general: 4113] pgpool show both nodes as standby after a failover

[Christophe Le Roux]

Hello,

I'm trying to setup a dual node HA architecture with postgresql 9.3 (with streaming replication) and pgpool 3.4.3 (with watchdog).

Before the failover, pgpool show the right configuration :

psql -hserv-e-pgpool-vip.mydomain.net -p 9999 -U postgres -c 'show pool_nodes'
node_id |  hostname   | port | status | lb_weight |  role
---------+-------------+------+--------+-----------+---------
0       | serv-ed01 | 5432 | 2      | 0.500000  | primary
1       | serv-ed02 | 5432 | 2      | 0.500000  | standby
(2 rows)


After the failover, show pool_nodes display that :

psql -hserv-e-pgpool-vip.mydomain.net -p 9999 -U postgres -c 'show pool_nodes'
node_id |  hostname   | port | status | lb_weight |  role
---------+-------------+------+--------+-----------+---------
0       | serv-ed01 | 5432 | 3      | 0.500000  | standby
1       | serv-ed02 | 5432 | 2      | 0.500000  | standby
(2 rows)


I have configured sr_check* like this :

# - Streaming -

sr_check_period = 10
                                   # Streaming replication check period
                                   # Disabled (0) by default
sr_check_user = 'postgres'
                                   # Streaming replication check user
                                   # This is neccessary even if you disable streaming
                                   # replication delay check by sr_check_period = 0
sr_check_password = 'xxx'
                                   # Password for streaming replication check user
delay_threshold = 10000000
                                   # Threshold before not dispatching query to standby node
                                   # Unit is in bytes
                                   # Disabled (0) by default


I don't know where is my mistake, can you help me please ?


Ps: the failover script is triggered and do his job normaly (so the serv-ed02 is really a new primary).


Regards,


LE ROUX Christophe
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20151013/8b522f98/attachment.htm>