Re: connection watchdog

From: "Magnus Naeslund(f)" <mag(at)fbab(dot)net>
To: "frbn" <frbn(at)efbs-seafrigo(dot)fr>, "Michael Kichanov" <mike(at)nordlink(dot)ru>
Cc: <mike(at)nordlink(dot)ru>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: connection watchdog
Date: 2002-10-10 18:15:05
Message-ID: 08fb01c27088$f564c3c0$f80c0a0a@mnd
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Kichanov <mike(at)nordlink(dot)ru> wrote:
>
> thanx, but now I doing just this thing :)
> and I would need something like PQping() ;)
>
> mike
>

In our listen/notify cache i just collect the socket and select() on it.
When it returns we do a PQconsumeInput(conn); i think that catches a
backend being killed for example.

Magnus

--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Programmer/Networker [|] Magnus Naeslund
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Josh Burdick 2002-10-10 19:08:39 question about executing JOINs
Previous Message Hector Galicia 2002-10-10 17:58:03 cursors