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,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. :)
Bert
On Thu, Apr 18, 2013 at 6:13 PM, Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> wrote:
On Apr 18, 2013, at 9:40 AM, Sofer, Yuval wrote:No, that's what synchronous means. What you're describing is asynchronous, and it seems like you should consider using asynchronous replication.
> 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?
--
Scott Ribe
scott_ribe@xxxxxxxxxxxxxxxx
http://www.elevated-dev.com/
(303) 722-0567 voice
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
--
Bert Desmet
0477/305361
