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@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