Re: Demoting master to slave without an rsync...is it safe?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Demoting master to slave without an rsync...is it safe?
Date: 2011-09-07 21:58:14
Message-ID: 4E67E8F6.9040101@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-09-07 22:02:45 Re: Problem using PostgreSQL 9.0.4 with Java
Previous Message Chris Redekop 2011-09-07 21:43:13 Re: Demoting master to slave without an rsync...is it safe?