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.<br /><br />Thanks.<br
/><br/><div class="gmail_quote">On Thu, Sep 16, 2010 at 7:34 PM, Fujii Masao <span dir="ltr"><<a
href="mailto:masao.fujii@gmail.com">masao.fujii@gmail.com</a>></span>wrote:<br /><blockquote class="gmail_quote"
style="margin:0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">On Fri,
Sep17, 2010 at 6:49 AM, fazool mein <<a href="mailto:fazoolmein@gmail.com">fazoolmein@gmail.com</a>> wrote:<br />
>I am designing a heartbeat system between replicas to know when a replica<br /> > goes down so that necessary
measurescan be taken. As I see, there are two<br /> > ways of doing it:<br /> ><br /> > 1) Creating a separate
heartbeatprocess on replicas.<br /> > 2) Creating a heartbeat message, and sending it over the connection that is<br
/>> already established between walsender and walreceiver.<br /> ><br /> > With 2, sending heartbeat from
walsenderto walreceiver seems trivial.<br /> > Sending a heartbeat from walreceiver to walsender seems tricky.
Going<br/> > through the code, it seems that the walreceiver is always in the<br /> > PGASYNC_COPY_OUT mode
(exceptin the beginning when handshaking is done).<br /> ><br /> > Can you recommend the right way of doing
this?<br/><br /></div>The existing keepalive feature doesn't help?<br /><br /> Regards,<br /><font color="#888888"><br
/>--<br /> Fujii Masao<br /> NIPPON TELEGRAPH AND TELEPHONE CORPORATION<br /> NTT Open Source Software Center<br
/></font></blockquote></div><br/>