Re: [HACKERS] PQping command line tool

2012-10-10 Thread Greg Stark
On Wed, Oct 10, 2012 at 6:11 PM, Greg Sabino Mullane wrote: > Jim Nasby pointed out: > >> It'd be useful to us to have a utility that could cleanly validate >> the server was up and communicating, without having to actually login. > > Well sure, but wouldn't it be even more useful to validate at t

Re: [HACKERS] PQping command line tool

2012-10-10 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Jim Nasby pointed out: > It'd be useful to us to have a utility that could cleanly validate > the server was up and communicating, without having to actually login. Well sure, but wouldn't it be even more useful to validate at the same time

Re: [HACKERS] PQping command line tool

2012-10-08 Thread Jim Nasby
On 10/4/12 11:34 AM, Greg Sabino Mullane wrote: 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 somethi

Re: [HACKERS] PQping command line tool

2012-10-04 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- 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 wrot

Re: [HACKERS] PQping command line tool

2012-10-03 Thread Tom Lane
Phil Sorber writes: > How about adding it as an option to psql? That's not to say that I > think we shouldn't also add it to 'pg_ctl status'. > I was looking at the code and originally I was using return code to > signify what the status was and some text output when quiet wasn't > set, but psql

Re: [HACKERS] PQping command line tool

2012-10-03 Thread Phil Sorber
On Wed, Oct 3, 2012 at 11:42 AM, Pavel Stehule wrote: > 2012/10/3 Phil Sorber : >> On Wed, Oct 3, 2012 at 11:35 AM, Bruce Momjian wrote: >>> On Tue, Oct 2, 2012 at 11:01:36PM -0400, Phil Sorber wrote: I was wondering recently if there was any command line tool that utilized PQping() or

Re: [HACKERS] PQping command line tool

2012-10-03 Thread Pavel Stehule
2012/10/3 Phil Sorber : > On Wed, Oct 3, 2012 at 11:35 AM, Bruce Momjian wrote: >> On Tue, Oct 2, 2012 at 11:01:36PM -0400, Phil Sorber wrote: >>> I was wondering recently if there was any command line tool that >>> utilized PQping() or PQpingParams(). I searched the code and couldn't >>> find an

Re: [HACKERS] PQping command line tool

2012-10-03 Thread Tom Lane
Bruce Momjian writes: > I don't see any tool using PQping except pg_ctl. Perhaps we should > modify "pg_ctl status" to use PQping. Right now is only checks the > postmaster.pid file, and checks to see that the pid is a running > postmaster. What it currently doesn't do is to check if the server

Re: [HACKERS] PQping command line tool

2012-10-03 Thread Phil Sorber
On Wed, Oct 3, 2012 at 11:35 AM, Bruce Momjian wrote: > On Tue, Oct 2, 2012 at 11:01:36PM -0400, Phil Sorber wrote: >> 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 th

Re: [HACKERS] PQping command line tool

2012-10-03 Thread Bruce Momjian
On Tue, Oct 2, 2012 at 11:01:36PM -0400, Phil Sorber wrote: > 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?

[HACKERS] PQping command line tool

2012-10-02 Thread Phil Sorber
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