Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help - Mailing list pgsql-sql

From Sofer, Yuval
Subject Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Date
Msg-id 2C0926ABD16BB641A8E2F11A549200423DDBC79BF6@PHXCCRPRD01.adprod.bmc.com
Whole thread Raw
Responses Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-sql
<div class="WordSection1"><p class="MsoPlainText"><span style="font-size:12.0pt;color:#1F497D">Hi, </span><p
class="MsoPlainText"><spanstyle="font-size:12.0pt;color:#1F497D"> </span><p class="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D">Iam using Postgres DB with stand by database, configured with streaming in
synchronizedmode (each commit on primary DB waits for commit on secondary DB).</span><p class="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D"> </span><pclass="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D">Sometimeswe suffer from network issues and as consequences, secondary machine is
notavailable.</span><p class="MsoPlainText"><span style="font-size:12.0pt;color:#1F497D"> </span><p
class="MsoPlainText"><spanstyle="font-size:12.0pt;color:#1F497D">In these situations, our application is stuck and do
notrespond anymore, since no confirmation comes from the secondary Postgres (obviously… it is down or unavailable….).
</span><pclass="MsoPlainText"><span style="font-size:12.0pt;color:#1F497D"> </span><p class="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D">Isthere any parameter that I can use, to enable recovering from hanging on until
someoneof us re-establish connection to secondary DB?</span><p class="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D">Maybesome configuration parameter that sets the time interval for being stuck
becauseof unavailable secondary Postgres? </span><p class="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D"> </span><pclass="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D">Pleasehelp, </span><p class="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D"> </span><pclass="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D">Thanks,</span><pclass="MsoPlainText"><span
style="font-size:12.0pt;color:#1F497D"> </span><pclass="MsoNormal"> <p class="MsoNormal"><b><span
style="font-family:"ArialNarrow","sans-serif"">Yuval Sofer</span></b><p class="MsoNormal"><b><span
style="font-family:"ArialNarrow","sans-serif"">BMC Software</span></b><p class="MsoNormal"><b><span
style="font-family:"ArialNarrow","sans-serif"">CTM&D Business Unit</span></b><p class="MsoNormal"><b><span
style="font-family:"ArialNarrow","sans-serif"">DBA Team</span></b><p class="MsoNormal"><b><span
style="font-family:"ArialNarrow","sans-serif"">972-52-4286-282</span></b><p class="MsoNormal"><a
href="mailto:yuval_sofer@bmc.com"><b><spanstyle="font-family:"Arial
Narrow","sans-serif";color:blue">yuval_sofer@bmc.com</span></b></a><b><spanstyle="font-family:"Arial
Narrow","sans-serif""></span></b><pclass="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal" dir="RTL"
style="text-align:right;direction:rtl;unicode-bidi:embed"><spandir="LTR"> </span><p class="MsoNormal"> </div> 

pgsql-sql by date:

Previous
From: bricklen
Date:
Subject: Re: copy from csv, variable filename within a function
Next
From: Andreas Kretschmer
Date:
Subject: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help