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

2013-04-18 Thread Bert
Hell**o 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 wrote: > On Apr 18, 2013, at 9:40 AM, Sofer, Yuval wrote: > > > Is the

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

2013-04-18 Thread Scott Ribe
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

[ADMIN] Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help

2013-04-18 Thread Sofer, Yuval
Hi, I am using Postgres DB with stand by database, configured with streaming in synchronized mode (each commit on primary DB waits for commit on secondary DB). Sometimes we suffer from network issues and as consequences, secondary machine is not available. In these situations, our applic