Re: Replication

Hi Bryan,

Bryan Irvine wrote:

>I'm creating a DB that is extremeley important to have running all the
>time.  Not for the importance of the data, but rather to keep the
>maximum uptime for the users.  The db actually gets dropped, and
>recreated and 1,000,000-ish records inserted every night.  I would like
>to create an identical db on seperate hardware that, in the event of
>hardware failure, the users could use while the hardware is getting
>replaced.  What is the best method (considering no money can be spent
>other than my time) to do this?
>
>
>
Have a look at pgrelicator http://pgreplicator.sourceforge.net/ or
postgreSQL-R
http://gborg.postgresql.org/project/pgreplication/projdisplay.php

Cheers

--
Noel Faux
Department of Biochemistry and Molecular Biology
Monash University
Clayton 3168
Victoria
Australia