Scott Whitney wrote: > 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. Uh, well, yes, that will work, but you don't have a valid archive _while_ the rsync is happening. I think that would be a problem if there was a failure during the rsync update. -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
