Re: Fwd: Reversing flow of WAL shipping - Mailing list pgsql-admin

From David Jantzen
Subject Re: Fwd: Reversing flow of WAL shipping
Date
Msg-id 79117255-5CB7-44A3-8DF8-74D647632BA8@ql2.com
Whole thread Raw
In response to Re: Fwd: Reversing flow of WAL shipping  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Fwd: Reversing flow of WAL shipping
Re: Fwd: Reversing flow of WAL shipping
List pgsql-admin
Thanks for the quick response Joshua, much appreciated.  Is there any
way to avoid or minimize a period without a warm standby when I switch
to Server B for production?  What about rsyncing the data directory
from Server B to Server C after B goes live?

On Oct 22, 2009, at 9:42 AM, Joshua D. Drake wrote:

>
>>>
>>> Here's the question: when I turn Server B into the
>>> production/provider
>>> node, it's going to switch into the next timeline.  If I then
>>> attempt
>>> to put Server A (or Server C) into recovery mode, will it switch to
>>>
>>> the new current timeline, or complain about being in the older
>>> timeline?  Do I have to take another full backup of Server B after
>>> it's become the production/provider node?
>
> You will need to do a new base backup.
>
> Joshua D. Drake
>
>>>
>>> Thanks,
>>> David
>>>
>>>
>>
>>
>
>
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
> Consulting, Training, Support, Custom Development, Engineering
> If the world pushes look it in the eye and GRR. Then push back
> harder. - Salamander
>


pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Fwd: Reversing flow of WAL shipping
Next
From: Scott Mead
Date:
Subject: Re: Fwd: Reversing flow of WAL shipping