<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<div style="font-family:Verdana,Arial,Helvetica,sans-serif; font-size:small; color:black">
<span style="font-family:Verdana,Arial,Helvetica,sans-serif; font-size:small; color:black">Dear Lou, why would you use multiple pgpool instances to control failover?<br>
<br>
Perhaps it would be a solution to have one instance of pgpool to set to FAILOVER and the others to DISALLOW...?
<br>
<br>
Ludwig <br>
<br>
Mobil gesendet.<br>
<br>
<span style="color:black">-----Original Message----- <br>
<b>From:</b> Lou Kamenov [kamenovl@defx.org]<br>
<b>Received:</b> Freitag, 20 Apr. 2012, 3:54<br>
<b>To:</b> Matt Wise [matt@nextdoor.com]<br>
<b>CC:</b> pgpool-general@pgpool.net [pgpool-general@pgpool.net]<br>
<b>Subject:</b> [pgpool-general: 360] Re: Multiple pgpool servers failover<br>
<br>
</span></span></div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">On Thu, Apr 19, 2012 at 9:32 PM, Matt Wise <matt@nextdoor.com> wrote:<br>
[..]<br>
> If DISALLOW_TO_FAILOVER is set and ..<br>
> a) one of the slaves fails: that slave is taken out of rotation until its<br>
> back up<br>
> b) the master fails: all connections hang until the master is back, OR a<br>
> new master is detected. pgpool goes into a loop looking for new masters.<br>
<br>
I was thinking more about section B, my problem is essentially an<br>
atomic fail-over,<br>
where we are ensured that this is triggered only once.<br>
<br>
I will give it a shot and post back my findings.<br>
<br>
If anyone else has any ideas, please send them over ;)<br>
<br>
cheers,<br>
Lou<br>
_______________________________________________<br>
pgpool-general mailing list<br>
pgpool-general@pgpool.net<br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
</div>
</span></font>
</body>
</html>