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
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 backu
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`/
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 /b
