equivalent to "replication_timeout" on standby server

From: Samba <saasira(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: equivalent to "replication_timeout" on standby server
Date: 2011-11-02 15:25:32
Message-ID: CAKgWO9Lpu5A9M-hu=WdxH7rboetpHFCi9bWjChPQZ3bhmdWeBw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 parameter that helps the WAL receiver
processes to terminate the idle connections on the standby servers?

It would be very useful (for monitoring purpose) if the termination of such
an idle connection on either master or standby servers is logged with
appropriate message.

Could some one explain me if this is possible with postgres-9.1.1?

Thanks and Regards,
Samba

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Treat 2011-11-02 15:55:35 Re: Server move using rsync
Previous Message Tom Lane 2011-11-02 14:26:50 Re: Performance Problem with postgresql 9.03, 8GB RAM, Quadcore Processor Server--Need help!!!!!!!