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
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
-postgresql.html
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Oct 10, 2007 11:39 AM
To: Scott Whitney
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Using rsync for base backups for PITR
Scott Whitney wrote:
I'm reading conflicting information
Scott Whitney wrote:
In the same way that you don't have a valid archive while the tar is
running, no? In either case, I have to archive the WAL segments used during
the file system backup, right?
Well, with the tar I assume you still have the old tar around. This is
not true with the rsync
On Wed, 2007-10-10 at 11:46 -0500, Scott Whitney wrote:
Is rsync a supported method for a warm standby server? Specifically, I'm
thinking about:
http://www.taygeta.com/ha-postgresql.html
That's dated 2001...
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com