Re: Demoting master to slave without an rsync...is it safe? - Mailing list pgsql-general

From John R Pierce
Subject Re: Demoting master to slave without an rsync...is it safe?
Date
Msg-id 4E67E8F6.9040101@hogranch.com
Whole thread Raw
In response to Re: Demoting master to slave without an rsync...is it safe?  (Chris Redekop <chris@replicon.com>)
List pgsql-general
On 09/07/11 2:43 PM, Chris Redekop wrote:
> my original question was: is it safe to bring a former master back up
> as a slave without doing a base-backup first? (using
> recovery_target_timeline='latest')
>

no.  you must first sync the new slave's files from the current master.
if you can do this with rsync odds are most of the old files on the
master won't need copying.   of course, this sync must be bracketed with
the same pg_start_backup() and pg_end_backup() as when the original
slave was created.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


pgsql-general by date:

Previous
From: Chris Redekop
Date:
Subject: Re: Demoting master to slave without an rsync...is it safe?
Next
From: "David Johnston"
Date:
Subject: Re: Problem using PostgreSQL 9.0.4 with Java