[Pgpool-general] online recovery by PITR - broken examples?

[Tomasz Chmielewski]

The online recovery by PITR described briefly here:

http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html#online-recovery

contains a "copy-base-backup" script, which is, in my opinion, broken:


#! /bin/sh
DATA=$1
RECOVERY_TARGET=$2
RECOVERY_DATA=$3

psql -c "select pg_start_backup('pgpool-recovery')" postgres
echo "restore_command = 'scp $HOSTNAME:/data/archive_log/%f %p'" > /data/recovery.conf
tar -C /data -zcf pgsql.tar.gz pgsql
psql -c 'select pg_stop_backup()' postgres
scp pgsql.tar.gz $RECOVERY_TARGET:$RECOVERY_DATA



For example, it includes $DATA variable, which is not used anywhere.

Is it the same as "/data" referenced later? Probably yes.

Anyway, I can't get it to work.

Does anyone have online recover with pgpool-ii explained in more details?


-- 
Tomasz Chmielewski
http://wpkg.org