[Pgpool-general] Online recovery by PITR vs rsync

[Ramon de Carvalho Valle]

Hi,

I would like to know the advantages/disadvantages between online
recovery by PITR vs rsync.

Currently, I am using the attached pgpool_recovery script (online
recovery by rsync) for both 1st and 2nd stage commands (some values are
hardcoded in the scripts intentionally) and would like some feedback. I
am using PostgreSQL 8.1.11 and pgpool-II 2.2.6 on CentOS 5.3 x86_64.

I am considering to use Marcelo's script:
http://www.mail-archive.com/pgpool-general@pgfoundry.org/msg00654.html


Best regards,
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_recovery
Type: application/x-shellscript
Size: 399 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20091227/ceb1c2e7/attachment.bin>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20091227/ceb1c2e7/attachment-0001.bin>