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 _______________________________________________ Pgpool-hackers mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-hackers
