<div dir="ltr">i think it does not work...<div><br></div><div><br></div><div><span style="color:rgb(51,102,153);font-family:monospace;font-size:13px"><span><a href="http://172.16.62.141/status.php" style="color:rgb(51,102,153);text-decoration:none" target="_blank">http://172.16.62.141/status.php</a></span></span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"> </span><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">IP Address Port Status Weight</span><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"> </span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">node 0 tad1 5432 Up. Connected. Running as primary server postgres: Up 0.500 |</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">node 1 tad2 5432 Up. Connected. Running as standby server postgres: Up 0.500 |</span><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"> </span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<br style="color:rgb(51,51,51);font-family:monospace;font-size:13px"><span style="color:rgb(51,102,153);font-family:monospace;font-size:13px"><span><a href="http://172.16.62.142/status.php" style="color:rgb(51,102,153);text-decoration:none" target="_blank">http://172.16.62.142/status.php</a></span></span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"> </span><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">IP Address Port Status Weight</span><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"> </span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">node 0 tad1 5432 Up. Connected. Running as primary server postgres: Up 0.500 |</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">node 1 tad2 5432 Up. Connected. Running as standby server postgres: Up 0.500 |</span><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"> </span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<br style="color:rgb(51,51,51);font-family:monospace;font-size:13px"><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">shutdown 141, node0, tad1...</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<br style="color:rgb(51,51,51);font-family:monospace;font-size:13px"><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px"><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px"></div><div>i attach logs....</div>
<div><br></div><div><br></div><div>this was the final result....</div><div><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">---></span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"> </span><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">IP Address Port Status Weight</span><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"> </span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">node 0 tad1 5432 Down postgres: Down 0.500 |</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)">node 1 tad2 5432 Up. Connected. Running as standby server postgres: Up 0.500 |</span><span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"> </span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
<span style="color:rgb(51,51,51);font-family:monospace;font-size:13px;background-color:rgb(253,253,253)"><---</span><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px"><br style="color:rgb(51,51,51);font-family:monospace;font-size:13px">
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Feb 12, 2014 at 4:11 AM, Yugo Nagata <span dir="ltr"><<a href="mailto:nagata@sraoss.co.jp" target="_blank">nagata@sraoss.co.jp</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
Thanks for sending confs & logs.<br>
<br>
I found that this problem occurs when load_balance_mode = off.<br>
Could you please try with load_balance_mode = on?<br>
<br>
I'll continue to analyze the detailed reason.<br>
<br>
On Mon, 10 Feb 2014 11:40:41 -0200<br>
<div class="HOEnZb"><div class="h5">Gonzalo Gil <<a href="mailto:gonxalo2000@gmail.com">gonxalo2000@gmail.com</a>> wrote:<br>
<br>
> i send the message but it was too long.<br>
> i'll attach the files....<br>
><br>
> it happens again, even when node 2 was the postgres standby node.<br>
><br>
> after i put the logs here, i shutdown node 1 (it has the primary database)<br>
> and it happens the same thing. node 2 lost ip and no failover happens.<br>
><br>
><br>
> TKS!<br>
><br>
><br>
><br>
><br>
> On Mon, Feb 10, 2014 at 5:23 AM, Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>> wrote:<br>
><br>
> > Hi,<br>
> ><br>
> > This is odd that pgpool-1 losts VIP when server2 goes down. For analysis,<br>
> > could you please send pgpool.conf and log output (of both pgpool1 and<br>
> > pgpool2)?<br>
> ><br>
> > On Tue, 4 Feb 2014 13:38:16 -0200<br>
> > Gonzalo Gil <<a href="mailto:gonxalo2000@gmail.com">gonxalo2000@gmail.com</a>> wrote:<br>
> ><br>
> > > Hello Tatsuo Ishii. I send some query mails to<br>
> > > pgpool-general@pgpool.netbut i don't get my own messagese. But i do<br>
> > > recieve other mails from the<br>
> > > forum.<br>
> > ><br>
> > > Can you answer me some questions or forward them to the forum!?<br>
> > ><br>
> > ><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<br>
> > 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<br>
> > it....and<br>
> > > pgpool1 too (!?)<br>
> > > i check network activity and saw that pgpool2 connects to server1 and<br>
> > make<br>
> > > the touch and i did see log from pgpool1 firing the failover command<br>
> > 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<br>
> > 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>
> ><br>
> ><br>
> > --<br>
> > Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
> ><br>
<br>
<br>
</div></div><span class="HOEnZb"><font color="#888888">--<br>
Yugo Nagata <<a href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br>
</font></span></blockquote></div><br></div>