Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, "Zucker, Yehudit" <Yehudit_Zucker(at)bmc(dot)com>, "Abraham, Danny" <danny_abraham(at)bmc(dot)com>, "Miller, Moshe" <Moshe_Miller(at)bmc(dot)com>
Subject: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Date: 2013-04-18 16:13:27
Message-ID: E320EEE2-FF06-4D69-959C-C115B3BA4DB8@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bert 2013-04-18 16:16:15 Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Previous Message Sofer, Yuval 2013-04-18 15:40:28 Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help