Re: [GENERAL] equivalent to replication_timeout on standby server

2011-11-06 Thread Fujii Masao
On Fri, Nov 4, 2011 at 10:58 PM, Samba saas...@gmail.com wrote: although both master(with replication_timeout)  and slave (with tcp timeout option in primary_conninfo parameter) closes the connection in quick time (based on tcp idle connection  timeout), as of now they do not log such

Re: [GENERAL] equivalent to replication_timeout on standby server

2011-11-04 Thread Samba
Thanks Fuji for that I hint... I searched around on the internet for that trick and it looks like we can make the Standby close its connection to the master much earlier than it otherwise would;it is good for me now. But still there seems to be two problem areas that can be improved over time...

Re: [GENERAL] equivalent to replication_timeout on standby server

2011-11-03 Thread Fujii Masao
On Thu, Nov 3, 2011 at 12:25 AM, Samba saas...@gmail.com wrote: The postgres manual explains the replication_timeout to be used to Terminate replication connections that are inactive longer than the specified number of milliseconds. This is useful for the primary server to detect a standby

[GENERAL] equivalent to replication_timeout on standby server

2011-11-02 Thread Samba
Hi all, The postgres manual explains the replication_timeout to be used to Terminate replication connections that are inactive longer than the specified number of milliseconds. This is useful for the primary server to detect a standby crash or network outage Is there a similar configuration