<div dir="ltr">Somebody can help me out?<div><br></div><div>Documentation sais:</div><div><br></div><div><h3 style="margin-top:30px;border-width:2px 2px 2px 10px;border-style:solid;border-color:rgb(140,216,226);padding:5px;margin-left:40px;background-color:rgb(244,248,241);color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif">
Coordinating multiple pgpool-IIs</h3><p style="margin:3px 25px 3px 40px;text-indent:1em;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px">Watchdog coordinates multiple pgpool-IIs by exchanging information with each other.</p>
<ul style="margin-left:40px;padding-right:30px;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px"><li style="padding-right:30px;list-style:square;color:rgb(102,51,51)">When backend node status changes by failover etc., watchdog notifies the information to other pgpool-IIs and synchronizes them. When online recovery occurs, watchdog restricts client connections to other pgpool-IIs for avoiding inconsistency between backends.</li>
<li style="padding-right:30px;list-style:square;color:rgb(102,51,51)">Commands on failback or failover (<a href="http://www.pgpool.net/docs/latest/pgpool-en.html#FAILOVER_COMMAND" style="color:blue">failover_command</a>, <a href="http://www.pgpool.net/docs/latest/pgpool-en.html#FAILBACK_COMMAND" style="color:blue">failback_command</a>, <a href="http://www.pgpool.net/docs/latest/pgpool-en.html#FOLLOW_MASTER_COMMAND" style="color:blue">follow_master_command</a>) <b>are executed by only one</b> pgpool-II by interlocking.</li>
</ul><div><font color="#663333" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:12px">Tutorial </span></font></div></div><div><a href="http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en.html">http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_master_slave/en.html</a><font color="#663333" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:12px"><br>
</span></font></div><div><br></div><div>sais:</div><div><h1 id="sync_node_info" style="margin-top:50px;border-bottom-width:2px;border-bottom-style:solid;border-bottom-color:rgb(102,153,204);padding:5px;margin-left:10px;background-color:rgb(102,153,204);color:rgb(255,255,255);font-family:Verdana,Arial,Helvetica,sans-serif">
Nodes information synchronization</h1><p style="margin:3px 25px 3px 40px;text-indent:1em;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px">In the case that multiple PostgreSQL are sharing, watchdog synchronizes the DB node statuses information between pgpool-II. When failover command (attaching, detaching, or promoting node) is executed in any pgpool-II, the same command is executed in all other pgpool-II.</p>
<p style="margin:3px 25px 3px 40px;text-indent:1em;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px"><br></p><p style="margin:3px 25px 3px 40px;text-indent:1em;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px">
<br></p><p style="margin:3px 25px 3px 40px;text-indent:1em;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px"><br></p><p style="margin:3px 25px 3px 40px;text-indent:1em;color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:12px">
<br></p></div><div><font color="#663333" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:12px"><br></span></font></div><div><font color="#663333" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:12px">So... does every node do the failover or just the active one?</span></font></div>
<div><font color="#663333" face="Verdana, Arial, Helvetica, sans-serif"><span style="font-size:12px">I think all does...</span></font></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Feb 4, 2014 at 9:25 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">> Hello Tatsuo Ishii. I send some query mails to<br>
</div>> pgpool-general@pgpool.netbut i don't get my own messagese. But i do<br>
<div class="im">> recieve other mails from the<br>
> forum.<br>
<br>
</div>"<a href="mailto:gonxalo2000@gmail.com">gonxalo2000@gmail.com</a>" has been already subscribed. I have no idea<br>
why you don't see your own message.<br>
<div class="im"><br>
> Can you answer me some questions or forward them to the forum!?<br>
<br>
</div>Forwarded.<br>
<div class="HOEnZb"><div class="h5"><br>
> I'm runing pgpool with streaming replication: pgpool1 - db postgres1<br>
> (server 1) and pgpool2 - db postgres 2 (server 2).<br>
> I'm using watchdog with a virtual ip and life_check_query.<br>
><br>
> It's all configured and working .... more or less....<br>
><br>
> INIT: I start my system: postgres1 is standby database and postgres2<br>
> is master (streaming replication).<br>
> pgpool1 has the virtual ip.(and pgpool2 no, obviously)<br>
><br>
> i connect to database via pgpool and everithing is ok.<br>
> i stop postgres1 and nothing happens because i check new_master <><br>
> old_master (no master failure).<br>
> i start postgres1 again (and returning it with pgpoolAdmin) or call a<br>
> recovery and it works great.<br>
><br>
> I stop postgres2 and failover fires ... and i get postgres1 as the new<br>
> primary.<br>
> and so on...<br>
><br>
> this works fine.<br>
><br>
><br>
> i go back to INIT again....<br>
> and i do in server2<br>
> reboot -h now<br>
><br>
> i see in the server1 (pgpool1) log that pgpool2 is down...ok<br>
> watching the log, i see pgpool1 lost the virtual ip address (!?)....and<br>
> tell me to restart pgpool....(!?)<br>
><br>
> i restart it and i see that failover fires ... but in the failover script i<br>
> get new_master_node = old_master_node ...and thus i do not make touch and<br>
> postgres1 keeps as a standby...<br>
><br>
><br>
> I change failover.sh (and the command in the pgpool.conf). i include all<br>
> parameters to see it's values when failover.sh start....<br>
><br>
> Then, i restart serve2 and "return" database to pgpool....<br>
><br>
> again, pgpool1 has the virtual ip.<br>
> i stop database in node 2 and failover fires.... but pgpool2 does it....and<br>
> pgpool1 too (!?)<br>
> i check network activity and saw that pgpool2 connects to server1 and make<br>
> the touch and i did see log from pgpool1 firing the failover command too....<br>
><br>
><br>
><br>
> Cuestions....<br>
> 1. why pgpool1 lost virtual ip and ask me to restart!?<br>
> 2. why pgpool2 fires failover? i thought just the "primary" pgpool (the one<br>
> with the virtual ip) fires it.<br>
><br>
><br>
> i hope you understand mr.<br>
> tks a lot for your time..<br>
> sorry for my english.<br>
</div></div></blockquote></div><br></div>