Postgres Pro
Downloads
Home   >   mailing lists

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

From Bert
Subject Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Date
Msg-id CAFCtE1=UdQjXGXqwTOwt5AZbxXjEC55gHw_Uq0nnHzk0Tqcs4A@mail.gmail.com
Whole thread Raw
In response to Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help  (Scott Ribe <scott_ribe@elevated-dev.com>)
List pgsql-admin
Tree view
Hello Yuval,

I would suggest to buy a third server if you want to do synchronous replication.

However, if your network is broken, I would first fix the network. :)

cheers,
Bert


On Thu, Apr 18, 2013 at 6:13 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
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



--
Bert Desmet
0477/305361

pgsql-admin by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help
Next
From: chanh.tran@free.fr
Date:
Subject: Pb migrating database from Postgres 8.1 to 8.4