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