[pgpool-general: 2160] pgpool is taking wrong node for a master

[Armin Nesiren]

Hello,

i have a little problem, or scenario that is happening and that I want to
avoid.

Here is scenario:

I have two nodes named node1, and node2. node1 is primary, node2 is standby.

- node1 fails
- pgpool promote node2 to primary
- i restart pgpool service for whatever reason
- pgpool is taking old primary (node1),to be primary again, even last state
was that node2 is primary
- pgpool is working with node1 as primary for some time, with old data


After this,it is hard to check which node have newer data, and its hart not
to lose one piece of data.

How it is possible that pgpool take node1 as primary even if last state was
that node2 was primary?

What is the best practice for this kind of situation?

Thanks
-- 
Armin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130925/21336174/attachment.html>