From: | Magnus Hagander <magnus(at)hagander(dot)net> |
---|---|
To: | Boszormenyi Zoltan <zb(at)cybertec(dot)at> |
Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org, Hans-Jürgen Schönig <hs(at)cybertec(dot)at> |
Subject: | Re: [PATCH] Make pg_basebackup configure and start standby |
Date: | 2012-10-03 08:25:07 |
Message-ID: | CABUevEyEG=_DsZcCnsyhSzgwH2o2OevL5JP8iHMKWdpVB9053Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | Postg와이즈 토토SQL |
On Tue, Jul 3, 2012 at 9:47 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> On mån, 2012-07-02 at 01:10 +0900, Fujii Masao wrote:
>> > But I think that part is lacking in functionality: AFAICT it's
>> > hardcoded to only handle host, port, user and password. What about
>> > other connection parameters, likely passed to pg_basebackup through
>> > the environment in that case? isn't that quite likely to break the
>> > server later?
>>
>> What about something like PQconninfo which returns the connection
>> string value established at connection?
>>
>> > Maybe the proper way around that is to provide the ability for
>> > pg_basebackup to take a full connection string, just like we allow
>> > psql to do?
>>
>> +1
>>
> I think both of these would be necessary to make this work smoothly.
>
> You also need to take into account situations like when pg_basebackup
> found a server with the help of PG* environment variables that might no
> longer be set when the server tries to start recovery. So you need
> something like PQconninfo.
Zoltan,
are you planning to work on the things discussed in this thread? I
notice the patch is sitting with "waiting on author" in the CF app -
so the second question is that if you are doing that, do you think it
will be done within the scope of the current CF?
--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2012-10-03 08:27:46 | Re: Support for REINDEX CONCURRENTLY |
Previous Message | Andres Freund | 2012-10-03 08:10:52 | Re: Support for REINDEX CONCURRENTLY |