| From: | "Tim Uckun" <timuckun(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Data Replication |
| Date: | 2008-12-11 02:21:04 |
| Message-ID: | 855e4dcf0812101821l1a344760sb579e43c652cf88@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Dec 11, 2008 at 1:05 PM, David Wall <d(dot)wall(at)computer(dot)org> wrote:
> We've done warm standby as you indicate, and we've not needed anything
> special.
Thanks for sharing your configuation. I have one additional question thought...
How do you handle the reverting? For example.
Say I have a primary database which is located at my main data center.
I am log shipping to a secondary data center.
My primary database server goes down.
Presume I have some scripts or something which detects this and
switches to the secondary.
What happens when I bring the primary back on line. I now want this to
be primary again and catch up on all the transactions that were sent
to the secondary. I want the secondary to resume it's backup status.
Is there a product which enables this kind of functionality?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-12-11 02:26:51 | Re: Data Replication |
| Previous Message | Guy Rouillier | 2008-12-11 01:28:19 | Re: Ubuntu for servers (was TurnKey PostgreSQL) |