[Pgpool-general] We really need a change to the API for calling recovery

[Tatsuo Ishii]

> On Thu, 2011-07-21 at 13:27 +0900, Tatsuo Ishii wrote:
>> > Tatsuo,
>> > 
>> > Currently the recovery routine is called on the current master database,
>> > and the parameters passed to it do not include the master database IP
>> > address or hostname.  Given that the way to provision a node with 9.1
>> > replication is via pg_basebackup, which MUST be run on the standby, this
>> > makes writing a recovery script which actually works rather difficult
>> > and unreliable.
>> > 
>> > I really think that you need to look at restructuring how the recovery
>> > call for new nodes works.  What I would prefer is to have a script which
>> > is called *on the pgpool server* itself, and not on the master node.
>> > This script would be passed the master address and the standby address;
>> > I don't think it would need any other parameters.
>> 
>> Maybe that is only true for streaming replication. I would think about
>> how to deal with pg_basebackup. BTW, I think the script would need
>> user, password and port number at least.
>> 
>> > If that's impossible for some reason, can we at least pass the master
>> > address to the recovery script?  Working without it is unnecessarily
>> > difficult.
>> 
>> That would be easy. I would do it for 3.1.
> 
> I thought the idea was to work on 9.1 for 3.2. Anyway, if we keep adding
> things to 3.1, it will never be released.

I've been waiting for French, Germany translations are coming. I hoped
these are included in 3.1.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp