[Pgpool-hackers] [Pgpool-general] pgpool limitations

[Tatsuo Ishii]

> On Thu, Jul 28, 2011 at 6:05 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> >     I have configured pgpool 3.0.3 in master/slave mode and setup
>> streaming
>> Note that pgpool-II 3.0.4 is the latest stable release.
>>
>>
> I am using the version that EnterpriseDB bundles with PPAS (Postgres Plus
> Advanced Server)

Oh, you could ask help from EDB support team.

>> Because newly added node is likely to have out of sync databases. Thus
>> bringing it online immediately will allow user to use obsolete
>> databases. You should do online recovery first.
>>
> 
> Since the new slave being added is configured using streaming replication,
> it is lagging behind the master just as much as any other currently
> configured slave. So from that standpoint the new slave should be allowed to
> serve queries.

It will be possible with pgpool-II 3.1 (without resetting existing connections).

> I guess we should allow for the case where we want to add an existing slave,
> which was configured independent of pgpool.

I'm not sure what you want here but It will be possible with pgpool-II
3.1 (without resetting existing connections).
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp