Re: [PATCH] pg_isready (was: [WIP] pg_ping utility)

From: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
To: Phil Sorber <phil(at)omniti(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Erik Rijkers <er(at)xs4all(dot)nl>, Dimitri Fontaine <dimitri(at)2ndquadrant(dot)fr>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCH] pg_isready (was: [WIP] pg_ping utility)
Date: 2013-06-10 18:08:34
Message-ID: CAHGQGwHiX8QPGAx-W=R1=1BebD8c5ZonORhnKR=ceQz5EggKmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Jun 3, 2013 at 2:14 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> Sorry for the delay in responding to you.
>
> On Mon, Feb 11, 2013 at 6:03 AM, Phil Sorber <phil(at)omniti(dot)com> wrote:
>> On Fri, Feb 8, 2013 at 1:07 PM, Phil Sorber <phil(at)omniti(dot)com> wrote:
>>> On Fri, Feb 8, 2013 at 12:46 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>>>> No maybe. But I think that all the client commands should follow the
>>>> same rule. Otherwise a user would get confused when specifying
>>>> options.
>>>
>>> I would consider the rest of the apps using it as a consensus. I will
>>> make sure it aligns in behavior.
>>>
>>
>> I've done as you suggested, and made sure they align with other
>> command line utils. What I have found is that dbname is passed
>> (almost) last in the param array so that it clobbers all previous
>> values. I have made this patch as minimal as possible basing it off of
>> master and not off of my previous attempt. For the record I still like
>> the overall design of my previous attempt better, but I have not
>> included a new version based on that here so as not to confuse the
>> issue, however I would gladly do so upon request.
>>
>> Updated patch attached.
>
> Thanks! The patch basically looks good to me.
>
> I updated the patch against current master and fixed some problems:
>
> - Handle the hostaddr in the connection string properly.
> - Remove the character 'V' from the third argument of getopt_long().
> - Handle the error cases of PQconninfoParse() and PQconndefaults().
> - etc...
>
> Please see the attached patch.

Committed.

Regards,

--
Fujii Masao

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Josh Berkus 2013-06-10 18:34:23 Re: Vacuum, Freeze and Analyze: the big picture
Previous Message Tom Lane 2013-06-10 17:38:29 Re: pg_filedump 9.3: checksums (and a few other fixes)