<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">I think the problem you should be
trying to solve is that you didn't know about the failover.<br>
<br>
You have several options for monitoring that. I have the
failover_command in pgpool.conf send an alert as well as perform
the failover. In case that somehow doesn't make it through, I
have another script tailing the pgpool logs for "health_check:
(\d+) th DB node status: (\d)$" and if the second number isn't 2,
it sends an alert. It also makes sure the health check is in the
last two minutes, which assures me the health checks are running.
You could get the same information from pcp_pool_status if you'd
prefer to monitor remotely through Nagios or something.<br>
<br>
<br>
alex<br>
<br>
<br>
On 11/8/12 12:57 AM, Meister, Klaus wrote:<br>
</div>
<blockquote
cite="mid:3A0A411015CB8247B210175B1A95D1E307B621D2@exchange-mbs1.mecom.de"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<meta name="Generator" content="Microsoft Word 12 (filtered
medium)">
<style>
<!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.E-MailFormatvorlage17
        {mso-style-type:personal-compose;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page Section1
        {size:612.0pt 792.0pt;
        margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
        {page:Section1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal">Hi pgpool-hackers,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">we are using pgpool2-3.1.3 in a productive
environment with streaming replication.<o:p></o:p></p>
<p class="MsoNormal">For the single point of failure pgpool we
have a corosync/pacemaker configuration on each database
machine.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Once we had an automatic failover
(because of a network failure) wich worked fine but which we
did not realize!(?)<o:p></o:p></p>
<p class="MsoNormal">2 weeks later there was another failover
(wich worked fine too :) and we were back on the obsolete
database which was still up and open.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">To prevent this we are planning to use the
pgpool_status file on a shared storage and use it on
startup/failover/switchover …<o:p></o:p></p>
<p class="MsoNormal">This file seems to be written only in case
of cleanly stopping the ppool.<o:p></o:p></p>
<p class="MsoNormal">I think it would be useful to do this every
time the status of a node is being changed.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Maybe is there another recommended way to
solve our problem.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">With kind regards<o:p></o:p></p>
<p class="MsoNormal">Klaus Meister<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">-- <o:p></o:p></p>
<p class="MsoNormal">Dipl.-Phys. Klaus Meister<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Datenbankadministrator<o:p></o:p></p>
<p class="MsoNormal">mecom Medien-Communikations-Gesellschaft
mbH<o:p></o:p></p>
<p class="MsoNormal">Mittelweg 143<o:p></o:p></p>
<p class="MsoNormal">D 20148 Hamburg<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Tel: +49 40 4113-32824<o:p></o:p></p>
<p class="MsoNormal">Fax: +49 40 451962<o:p></o:p></p>
<p class="MsoNormal">Web: <a class="moz-txt-link-rfc2396E" href="http://www.mecom.de/"><http://www.mecom.de/></a><o:p></o:p></p>
<p class="MsoNormal">Registergericht Hamburg, HRB 43177<o:p></o:p></p>
<p class="MsoNormal">Geschäftsführer: Ulrich Wiehsalla, Barbara
Bliefert<o:p></o:p></p>
<p class="MsoNormal">--------------------------------------------------------------<o:p></o:p></p>
<p class="MsoNormal">Sollten Sie nicht der beabsichtigte
Empfänger sein, <o:p></o:p></p>
<p class="MsoNormal">informieren Sie bitte den Absender dieser
E-Mail entsprechend.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
pgpool-hackers mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers">http://www.pgpool.net/mailman/listinfo/pgpool-hackers</a>
</pre>
</blockquote>
<br>
</body>
</html>