<div dir="ltr">Thank you! I will try this method definitely. By the way, what I really need is to fail the transaction when slave is down. Using this method I can identify the status of the slave node, then will try to make the master node read only until the slave comes online.</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><br><div>Thanks,</div><div>Anushka</div></div></div></div>
<br><div class="gmail_quote">On Thu, Mar 16, 2017 at 6:36 PM, Lazaro Garcia <span dir="ltr"><<a href="mailto:lazaro3487@gmail.com" target="_blank">lazaro3487@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="ES" link="#0563C1" vlink="#954F72"><div class="m_5835934572700061491WordSection1"><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">When slave goes down, pgpool detects that and triggers a failover, then the master remains active and the slave are marked as down state. On the failover_command of pgpool, you could execute a command that drop the slave from the master synchronous_standby_names and reload the configuration on the master. By this way new transactions can be executed on the master without checking the state of the slave because synchronous replication has been disabled.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">If you recover the slave you can attach this server to master again an activate the synchronous replication.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">Regards.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">De:</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> <a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.<wbr>net</a> [mailto:<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-<wbr>bounces@pgpool.net</a>] <b>En nombre de </b>Anushka Weerakkodyge<br><b>Enviado el:</b> miércoles, 15 de marzo de 2017 05:37 p. m.<br><b>Para:</b> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br><b>Asunto:</b> [pgpool-general: 5370] [pgpool] Streaming Replication - Identify Slave Node Status<u></u><u></u></span></p><div><div class="h5"><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Hi all,<u></u><u></u></p><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">I have a synchronous streaming replication environment which is implemented using inbuilt replication mechanism in postgresql. There is a requirement that I need to fail the data modification transactions on master node if the slave node is down. (ie: transactions should commit when only both servers are up and running) <u></u><u></u></p></div><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Please let me know whether there is a way to identify slave node status and fail the transaction using pgpool ? <br clear="all"><u></u><u></u></p><div><div><div><p class="MsoNormal"><u></u> <u></u></p><div><p class="MsoNormal">Thanks,<u></u><u></u></p></div><div><p class="MsoNormal">Anushka<u></u><u></u></p></div></div></div></div></div></div></div></div></div></div></blockquote></div><br></div>