[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