Postgres Pro
Downloads
Home   >   mailing lists

Using rsync for base backups for PITR - Mailing list pgsql-admin

From Scott Whitney
Subject Using rsync for base backups for PITR
Date
Msg-id 20071010163344.2CA723F2361@mail.int.journyx.com
Whole thread Raw
Responses Re: Using rsync for base backups for PITR  (Bruce Momjian <bruce@momjian.us>)
List pgsql-admin
Tree view 
I'm reading conflicting information on this. Is this a supported technique?

start_backup
rsync the initial base backup
stop_backup

Then, periodically,
start_backup
rsync again
stop_backup

It's my opinion that this wouuld significantly cut down the 30GB base backup
I'll need to take for each PITR.

pgsql-admin by date:

Previous
From: Decibel!
Date:
Subject: Re: warm/hot backup of Postgresql
Next
From: Bruce Momjian
Date:
Subject: Re: Using rsync for base backups for PITR