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
On Tuesday 16 September 2008, Joey K. [EMAIL PROTECTED] wrote:
Hello,
Just to be sure of our backups we plan to do a base + full backups (yes,
we are overly paranoid)
(1) (`date`)
(2) perform hot rsync first (while the database is running)
$ rsync -avr pgdata /backup/`date`/
(3) stop
On Tue, 16 Sep 2008, Joey K. wrote:
(1) pg_start_backup(`date`)
(2) perform hot rsync first (while the database is running)
$ rsync -avr pgdata /backup/`date`/
(3) stop pg
You need to call pg_stop_backup() here and wait until the last WAL file it
references has been archived before this
On Tue, 2008-09-16 at 21:16 +0530, Joey K. wrote:
This didn't work and not sure if this is supposed to work ;-)
Or should I stick to just plain PITR?
Yes, just drop steps (3) and (5). If you don't trust it for some reason,
then don't use it at all - mixing modes like that won't work. But we