[pgpool-general: 2404] Streaming replication: promoting the only alive backend server on pgpool start

Sergey Arlashin sergeyarl.maillist at gmail.com
Tue Jan 14 18:09:25 JST 2014


Hi!

Say we have a degraded master-slave backend with only one server alive which is currently slave. Master is dead, slave is alive. Pgpool is switched off (it is essential). 
Now I switch on pgpool2 service and it shows the following status:


postgres=# show pool_nodes;
 node_id |   hostname    | port | status | lb_weight |  role
---------+---------------+------+--------+-----------+---------
 0       | db-node1.site | 5432 | 2      | 0.500000  | standby
 1       | db-node2.site | 5432 | 3      | 0.500000  | standby
(2 rows)

The only alive server is standby. 
And also I cannot see anything related to failover in pgpool log. 

So the question is - is there a way for pgpool to detect ON START that the only alive server is in standby state and automatically promote it to master by running failover command or something similar? 

--
Best regards,
Sergey Arlashin


More information about the pgpool-general mailing list