Hello,
Just to be sure of our backups we plan to do a base + full backups (yes, we
are overly paranoid)
(1) pg_start_backup(`date`)
(2) perform hot rsync first (while the database is running)
$ rsync -avr pgdata /backup/`date`/
(3) stop pg
(4) perform cold rsync
$ rsync -avr --delete pgdata /backup/`date`/
(5) start pg
(6) pg_stop_backup()
This didn't work and not sure if this is supposed to work ;-)
Or should I stick to just plain PITR?
Thanks,
Steve