Postgres Pro
Downloads
Home   >   mailing lists

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

From Scott Ribe
Subject Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Date
Msg-id E320EEE2-FF06-4D69-959C-C115B3BA4DB8@elevated-dev.com
Whole thread Raw
In response to Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help  ("Sofer, Yuval" <Yuval_Sofer@bmc.com>)
Responses Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help  (Bert <biertie@gmail.com>)
List pgsql-admin
Tree view 
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
connectionto 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
asynchronousreplication. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice

pgsql-admin by date:

Previous
From: "Sofer, Yuval"
Date:
Subject: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Next
From: Bert
Date:
Subject: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help