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

From: Phil Sorber <phil(at)omniti(dot)com>
To: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, 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-02-03 02:55:29
Message-ID: CADAkt-hnB3OhCpkR+PCg1c_Bjrsb7J__BPV+-jrjS5opjR2oww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 29, 2013 at 11:43 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
> On Tue, Jan 29, 2013 at 3:12 AM, Alvaro Herrera
> <alvherre(at)2ndquadrant(dot)com> wrote:
>> Phil Sorber escribió:
>>> On Mon, Jan 28, 2013 at 11:20 AM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>>> > Maybe. But I'm not inclined to add new libpq interface at this stage.
>>> > Because we are in the last CommitFest and I'm not sure whether
>>> > we have enough time to implement that. Instead, how about using
>>> > both PQconninfoParse() and PQconndefaults() like uri-regress.c does?
>>> > Or just remove that output message? At least I don't think that the
>>> > information about host and port needs to be output. Which would make
>>> > the code very simpler.
>>>
>>> I think that output is important as do others up thread. I think it'd
>>> be simpler to just disable dbname's ability to double as conninfo. If
>>> we are looking for easy, that is.
>>>
>>> I don't mind duplicating the behavior from conninfo_array_parse() or
>>> uri-regress.c either. I can just put a comment that at some point in
>>> the future we should add a libpq interface for it.
>>
>> I suggest duplicate the code for 9.3, and submit a patch to refactor
>> into a new libpq function for CF2013-next. If the patch is simple
>> enough, we can consider putting it into 9.3.
>
> Agreed.
>
> Regards,
>
> --
> Fujii Masao

OK, here is the patch that handles the connection string in dbname.
I'll post the other patch under a different posting because I am sure
it will get plenty of debate on it's own.

Attachment Content-Type Size
pg_isready_con_str.diff application/octet-stream 2.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Phil Sorber 2013-02-03 03:16:29 [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq
Previous Message Gavin Flower 2013-02-03 02:47:34 Re: autovacuum not prioritising for-wraparound tables