On Tue, Nov 27, 2012 at 12:26 AM, Peter Eisentraut
<peter_e@gmx.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
