Re: Heartbeat between Primary and Standby replicas

Apologies. I'm new to Postgres and I didn't see that feature. It satisfies
what I want to do.

Thanks.

On Thu, Sep 16, 2010 at 7:34 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:

> On Fri, Sep 17, 2010 at 6:49 AM, fazool mein <fazoolmein(at)gmail(dot)com> wrote:
> > I am designing a heartbeat system between replicas to know when a replica
> > goes down so that necessary measures can be taken. As I see, there are
> two
> > ways of doing it:
> >
> > 1) Creating a separate heartbeat process on replicas.
> > 2) Creating a heartbeat message, and sending it over the connection that
> is
> > already established between walsender and walreceiver.
> >
> > With 2, sending heartbeat from walsender to walreceiver seems trivial.
> > Sending a heartbeat from walreceiver to walsender seems tricky. Going
> > through the code, it seems that the walreceiver is always in the
> > PGASYNC_COPY_OUT mode (except in the beginning when handshaking is done).
> >
> > Can you recommend the right way of doing this?
>
> The existing keepalive feature doesn't help?
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION
> NTT Open Source Software Center
>