<html><head></head><body><div class="ydp98645dd1yahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>when pgpool starts it will search for a primary node, it executes select pg_is_in_recovery(); on node 0 and if it is f (false) then it picks node 0 as primary otherwise it tries with the next node.</div><div><br></div><div>Are you sure that if you execute select pg_is_in_recovery() on both databases one of the two returns f and the other t ?</div><div><br></div><div>You should attach the pgpool log with the info when pgpool starts</div><div><br></div><div class="ydp98645dd1signature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="ydp1696df27yahoo_quoted_4954152393" class="ydp1696df27yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Wednesday, April 3, 2019, 4:27:12 PM GMT+2, Dmitry Medvedev <dm.dm.medvedev@gmail.com> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp1696df27yiv1553231343"><div dir="ltr"><div dir="ltr"><div>Hello to everyone. A couple of days I've spent trying to understand how</div><div>pgpool-II works.</div><div><br></div><div>After some cruel experiments I've broken my pgpool cluster (1 primary and 1 standby nodes) :-)</div><div><br></div><div>I've re-configured it and launched pgpool again. And now all nodes have "standby" role no matter what i do. Is there any way of reset pgpool? Nodes without pgpool operating correctly: one is primary, other is standby.</div></div></div></div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div>
</div>
</div></body></html>