From: Sofer, Yuval <Yuval_Sofer@bmc.com>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Cc: Zucker, Yehudit <Yehudit_Zucker@bmc.com>
Cc: Abraham, Danny <danny_abraham@bmc.com>
Cc: Miller, Moshe <Moshe_Miller@bmc.com>
Subject: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Date: Thu, 18 Apr 2013 10:41:22 -0500
Message-ID: <2C0926ABD16BB641A8E2F11A549200423DDBC79BF6@PHXCCRPRD01.adprod.bmc.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
Hi,
I am using Postgres DB with stand by database, configured with streaming in synchronized mode (each commit on primary DB waits for commit on secondary DB).
Sometimes we suffer from network issues and as consequences, secondary machine is not available.
In these situations, our application is stuck and do not respond anymore, since no confirmation comes from the secondary Postgres (obviously... it is down or unavailable....).
Is there any parameter that I can use, to enable recovering from hanging on until someone of us re-establish connection to secondary DB?
Maybe some configuration parameter that sets the time interval for being stuck because of unavailable secondary Postgres?
Please help,
Thanks,
Yuval Sofer
BMC Software
CTM&D Business Unit
DBA Team
972-52-4286-282
yuval_sofer@bmc.com<mailto:yuval_sofer@bmc.com>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Yuval_Sofer@bmc.com, Yehudit_Zucker@bmc.com, danny_abraham@bmc.com, Moshe_Miller@bmc.com
Subject: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
In-Reply-To: <2C0926ABD16BB641A8E2F11A549200423DDBC79BF6@PHXCCRPRD01.adprod.bmc.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox