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

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-admin by date

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

pgsql-general by date

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

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