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