Re: [WIP] pg_ping utility

On Tue, Nov 27, 2012 at 12:26 AM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:

> On 11/23/12 9:48 AM, Michael Paquier wrote:
> > We waited a couple of days for feedback for this feature. So based on
> > all the comments provided by everybody on this thread, perhaps we should
> > move on and implement the options that would make pg_ping a better
> > wrapper for PQPing. Comments?
>
> Personally, I still don't see the general utility of this. For
> monitoring, psql -c 'select 1' is much more useful. For network
> analysis, you can use network analysis tools. The niche for pg_ping in
> between those is so narrow that I cannot see it.
>
As a wrapper for PQPing, you can get different server status specific to
libpq which are PQPING_OK, PQPING_REJECT and PQPING_NO_RESPONSE, and
perhaps more in the future if PQPing is extended in a way or another. So
the purpose of this feature is to allow users to put there hands on a core
feature that would allow them to get a libpq-specific server status, and to
check the accessibility to the server with something lighter than a psql
client connection. Any additional comments Phil?
--
Michael Paquier
http://michael.otacoo.com