Re: Fwd: Reversing flow of WAL shipping

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: David Jantzen <djantzen(at)ql2(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 16:42:49
Message-ID: 1256229769.3378.6.camel@jd-desktop.unknown.charter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-hackers


> >
> > 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

Browse pgsql-admin by date

  From Date Subject
Next Message David Jantzen 2009-10-22 17:28:19 Re: Fwd: Reversing flow of WAL shipping
Previous Message David Jantzen 2009-10-22 16:34:42 Fwd: Reversing flow of WAL shipping

Browse pgsql-general by date

  From Date Subject
Next Message A.Bhattacharya 2009-10-22 16:45:01 Problem calling C function in PostgreSQL
Previous Message David Jantzen 2009-10-22 16:34:42 Fwd: Reversing flow of WAL shipping

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc Munro 2009-10-22 16:47:16 Re: Using views for row-level access control is leaky
Previous Message João Eugenio Marynowski 2009-10-22 16:35:21 table corrupted