Tuesday, September 16, 2008

[GENERAL] PITR and base + full backups


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?


No comments: