From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Sofer, Yuval <Yuval_Sofer@bmc.com>
Cc: pgsql-admin@postgresql.org, "Zucker, Yehudit" <Yehudit_Zucker@bmc.com>
Cc: Abraham, Danny <danny_abraham@bmc.com>
Cc: Miller, Moshe <Moshe_Miller@bmc.com>
Subject: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Date: Thu, 18 Apr 2013 10:13:27 -0600
Message-ID: <E320EEE2-FF06-4D69-959C-C115B3BA4DB8@elevated-dev.com> (raw)
In-Reply-To: <2C0926ABD16BB641A8E2F11A549200423DDBC79BF2@PHXCCRPRD01.adprod.bmc.com>
References: <2C0926ABD16BB641A8E2F11A549200423DDBC79BF2@PHXCCRPRD01.adprod.bmc.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On Apr 18, 2013, at 9:40 AM, Sofer, Yuval wrote:
> 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?
No, that's what synchronous means. What you're describing is asynchronous, and it seems like you should consider using asynchronous replication.
--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, 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: <E320EEE2-FF06-4D69-959C-C115B3BA4DB8@elevated-dev.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