[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


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