Fwd: Reversing flow of WAL shipping

From: David Jantzen <djantzen(at)ql2(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Fwd: Reversing flow of WAL shipping
Date: 2009-10-22 16:34:42
Message-ID: 0E8AE22F-F733-4F95-9073-F25C16C9A697@ql2.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-hackers

Hi, I sent this to general but haven't seen a response. I'm guessing this list is more appropriate.

Thanks.

Begin forwarded message:

From: David Jantzen <djantzen(at)ql2(dot)com<mailto:djantzen(at)ql2(dot)com>>
Date: October 21, 2009 8:52:59 PM PDT
To: "pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>" <pgsql-general(at)postgresql(dot)org<mailto:pgsql-general(at)postgresql(dot)org>>
Subject: Reversing flow of WAL shipping

Hey Folks,

I want to run a warm standby scenario by you. I'm pretty sure it'll
work, but it's a very large database so even the slightest mistake can
mean a major setback.

Scenario:

Server A is the provider node, shipping WAL files to Server B. Server
B is destined to become the provider node (newer hardware), and has a
sibling Server C that will be the warm standby.

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?

Thanks,
David

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2009-10-22 16:42:49 Re: Fwd: Reversing flow of WAL shipping
Previous Message Tom Lane 2009-10-22 14:19:53 Re: find query beening executed

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-10-22 16:42:49 Re: Fwd: Reversing flow of WAL shipping
Previous Message Dave Page 2009-10-22 15:32:53 PGDay.EU 2009 - registration deadline extended

Browse pgsql-hackers by date

  From Date Subject
Next Message João Eugenio Marynowski 2009-10-22 16:35:21 table corrupted
Previous Message Robert Haas 2009-10-22 16:29:39 Re: BUG #5021: ts_parse doesn't recognize email addresses with underscores