Re: Heartbeat between Primary and Standby replicas

Ah, great. I missed looking there.
Thanks.

On Sun, Sep 26, 2010 at 4:19 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:

> On Mon, Sep 27, 2010 at 7:46 AM, fazool mein <fazoolmein(at)gmail(dot)com> wrote:
> > I checked the code for the keepalive feature. It seems that the socket
> > options are only set on the primary's socket connection. The tcp
> connection
> > created on the secondary for walreceiver does not use the keepalive
> > parameters from the configuration.
>
> You can use libpq keepalive parameters for walreceiver.
>
> keepalives_idle
> keepalives_interval
> keepalives_count
> http://developer.postgresql.org/pgdocs/postgres/libpq-connect.html
>
> Those can be set in primary_connection in recovery.conf.
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION
> NTT Open Source Software Center
>