[Pgpool-hackers] pg_basebackup

[Tatsuo Ishii]

Hi,

PostgreSQL 9.1 introduces a client tool called "pg_basebackup" which
can take base backup of primary server. It seems it will be usefull if
it can be used for taking base backup while doing online recovery by
pgpool-II. A benefit with using pg_basebackup over using rsync or
other tools is, it does not require ssh access, which is annoying and
especially problematic with Windows.

However there's a serious downside with pg_basebackup: pgpool needs to
execute recovery_1st_stage_command(and recovery_2nd_stage_command)
from a special function "pgpool_recovery()" which must be executed on
primary. While pg_basebackup must be executed on standby.

Any idea to solve this?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp