Skip site navigation (1) Skip section navigation (2)

Re: Using rsync for base backups for PITR

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Scott Whitney <swhitney(at)journyx(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Using rsync for base backups for PITR
Date: 2007-10-10 16:39:27
Message-ID: 200710101639.l9AGdRr01651@momjian.us (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-admin by date

Next:From: Scott WhitneyDate: 2007-10-10 16:46:02
Subject: Re: Using rsync for base backups for PITR
Previous:From: Scott WhitneyDate: 2007-10-10 16:37:18
Subject: Using rsync for base backups for PITR

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group