Skip site navigation (1) Skip section navigation (2)

Re: PQping command line tool

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PQping command line tool
Date: 2012-10-04 16:34:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Hash: RIPEMD160

> I was wondering recently if there was any command line tool that
> utilized PQping() or PQpingParams(). I searched the code and couldn't
> find anything and was wondering if there was any interest to have
> something like this included? I wrote something for my purposes of
> performing a health check that also supports nagios style status
> output. It's probably convenient for scripting purposes as well.

I'm not sure how useful this information would be. Most health 
checks (Nagios or otherwise) really only care if things are 
working all the up to point A or not, where point A is usually 
a simple query such as "SELECT 1". Knowing various failure states 
as returned by PQping* does not seem to fit into such tools - 
any failure needs to be handled manually.

- -- 
Greg Sabino Mullane greg(at)turnstep(dot)com
End Point Corporation
PGP Key: 0x14964AC8 201210041146


In response to


pgsql-hackers by date

Next:From: Jaime CasanovaDate: 2012-10-04 16:48:42
Subject: Re: Make CREATE AGGREGATE check validity of initcond value?
Previous:From: Heikki LinnakangasDate: 2012-10-04 16:23:06
Subject: Re: Sharing more infrastructure between walsenders and regular backends (was Re: Switching timeline over streaming replication)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group