<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
<meta name="Generator" content="Microsoft Word 15 (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;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
span.Stylwiadomocie-mail17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></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]-->
</head>
<body lang="PL" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hello Tatsuo,<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US">Probably title of my post may seem to be strange but I wonder if there is any way to force pgpool to perform any action (for example run a custom script) after detection of failure on standby node? Pgpool works very fine
when detecting failures on primary, but sometimes it would be very helpful if it was able also react for standby node unavailability. I set up synchronous replication with two node postgres cluster and as you obviously expect everything goes fine until standby
node goes down with any reason – all transaction hang and wait for commit from standby. If pgpool could force primary node in any way to reload its configuration into asynchronous mode postgresql cluster could be still available for dml operations. Do You
know if this is possible with current mechanism implemented in pgpool to achieve such effect?<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US">Thank you in advance for your help.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span style="mso-ligatures:none;mso-fareast-language:PL">Andrzej Rozmus<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#161616;background:white;mso-ligatures:none;mso-fareast-language:PL">Starszy Technolog</span><span style="mso-ligatures:none;mso-fareast-language:PL"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#161616;mso-ligatures:none;mso-fareast-language:PL">Departament Systemów Administracji Rządowej</span><span style="mso-ligatures:none;mso-fareast-language:PL"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#161616;mso-ligatures:none;mso-fareast-language:PL">Dział Ministerstwo Finansów</span><span style="mso-ligatures:none;mso-fareast-language:PL"><o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;mso-ligatures:none;mso-fareast-language:PL">Asseco Poland S.A.</span></b><span style="font-size:9.0pt;mso-ligatures:none;mso-fareast-language:PL"><br>
ul. Branickiego 13<br>
02-972 Warszawa<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#161616;background:white;mso-ligatures:none;mso-fareast-language:PL">tel. kom. +48 502 270 059</span><b><span style="mso-ligatures:none;mso-fareast-language:PL"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="mso-ligatures:none;mso-fareast-language:PL"><a href="mailto:andrzej.rozmus@asseco.pl"><span style="color:#0563C1">andrzej.rozmus@asseco.pl</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>