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.fu...@gmail.com> wrote: > On Fri, Sep 17, 2010 at 6:49 AM, fazool mein <fazoolm...@gmail.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 >