From: | David Jantzen <djantzen(at)ql2(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Reversing flow of WAL shipping |
Date: | 2009-10-22 03:52:59 |
Message-ID: | C5ED6D02-1C03-4A6B-A3C6-3262FE6E3CF1@ql2.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general pgsql-hackers |
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 | Julius Tuskenis | 2009-10-22 07:52:09 | find query beening executed |
Previous Message | Tena Sakai | 2009-10-22 03:12:21 | Re: Is it possible to have psql ignore the line I am typing? |
From | Date | Subject | |
---|---|---|---|
Next Message | semi-ambivalent | 2009-10-22 03:54:53 | Re: auto-filling a field on insert |
Previous Message | Scott Marlowe | 2009-10-22 03:42:52 | Re: postgres doesn't start after crash |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2009-10-22 04:55:11 | Re: Hot standby, prepared xacts, locks |
Previous Message | Itagaki Takahiro | 2009-10-22 02:33:10 | TRIGGER with WHEN clause |