Re: connection watchdog - Mailing list pgsql-general

From Magnus Naeslund(f)
Subject Re: connection watchdog
Date
Msg-id 08fb01c27088$f564c3c0$f80c0a0a@mnd
Whole thread Raw
In response to Re: connection watchdog  (Michael Kichanov <mike@nordlink.ru>)
List pgsql-general
Michael Kichanov <mike@nordlink.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
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


pgsql-general by date:

Previous
From: Hector Galicia
Date:
Subject: cursors
Next
From: Josh Burdick
Date:
Subject: question about executing JOINs