| From: | Noel <noel(dot)faux(at)med(dot)monash(dot)edu(dot)au> |
|---|---|
| To: | Bryan Irvine <bryan(dot)irvine(at)kingcountyjournal(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Replication |
| Date: | 2003-09-23 00:55:47 |
| Message-ID: | 3F6F9A13.9070502@med.monash.edu.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno LEVEQUE | 2003-09-23 06:36:58 | Re: Referencing multiple primary keys from a single table. |
| Previous Message | Bruno Wolff III | 2003-09-22 22:33:54 | Re: Referencing multiple primary keys from a single table. |