Re: Data Replication - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Data Replication
Date
Msg-id 1228962411.28319.0.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Re: Data Replication  ("Tim Uckun" <timuckun@gmail.com>)
Responses Re: Data Replication
List pgsql-general
On Thu, 2008-12-11 at 15:21 +1300, Tim Uckun wrote:

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

You have to run a new base backup and have the slave ship logs to the
master.

> Is there a product which enables this kind of functionality?
>

https://projects.commandprompt.com/public/pitrtools

--
PostgreSQL
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997


pgsql-general by date:

Previous
From: "Tim Uckun"
Date:
Subject: Re: Data Replication
Next
From: Phillip Berry
Date:
Subject: Startup process thrashing