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

From Joshua D. Drake
Subject Re: Fwd: Reversing flow of WAL shipping
Date
Msg-id 1256229769.3378.6.camel@jd-desktop.unknown.charter.com
Whole thread Raw
In response to Fwd: Reversing flow of WAL shipping  (David Jantzen <djantzen@ql2.com>)
Responses Re: Fwd: Reversing flow of WAL shipping  (David Jantzen <djantzen@ql2.com>)
List pgsql-admin
> >
> > 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: David Jantzen
Date:
Subject: Fwd: Reversing flow of WAL shipping
Next
From: David Jantzen
Date:
Subject: Re: Fwd: Reversing flow of WAL shipping