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