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

Re: Fwd: Reversing flow of WAL shipping

From: David Jantzen <djantzen(at)ql2(dot)com>
To: "jd(at)commandprompt(dot)com" <jd(at)commandprompt(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Fwd: Reversing flow of WAL shipping
Date: 2009-10-22 17:28:19
Message-ID: 79117255-5CB7-44A3-8DF8-74D647632BA8@ql2.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-hackers
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
>


In response to

Responses

pgsql-hackers by date

Next:From: Scott MeadDate: 2009-10-22 17:36:58
Subject: Re: Fwd: Reversing flow of WAL shipping
Previous:From: Dan O'HaraDate: 2009-10-22 17:10:07
Subject: Re: BUG #5021: ts_parse doesn't recognize email addresses with underscores

pgsql-admin by date

Next:From: Scott MeadDate: 2009-10-22 17:36:58
Subject: Re: Fwd: Reversing flow of WAL shipping
Previous:From: Joshua D. DrakeDate: 2009-10-22 16:42:49
Subject: Re: Fwd: Reversing flow of WAL shipping

pgsql-general by date

Next:From: Scott MeadDate: 2009-10-22 17:36:58
Subject: Re: Fwd: Reversing flow of WAL shipping
Previous:From: A.BhattacharyaDate: 2009-10-22 16:45:01
Subject: Problem calling C function in PostgreSQL

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