From: | Greg Pyhl <gregpyhl(at)yahoo(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Replication |
Date: | 2003-01-02 09:41:32 |
Message-ID: | 20030102094132.27526.qmail@web41201.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi,
I'm using PostgreSQL 7.2.1 (on top of RH7.3) and I
need to replicate/mirror the database (almost)
real-time on other host. In other words: main machine
has DB which is used/updated all the time. If the main
machine crashes/burns, the backup machine should have
replicated the DB so that with some simple configuring
the backup machine can replace the unusable main
machine.
I've take a quick look at the issue and found already
two alternatives which all may do the job for me:
Usogres:
http://usogres.good-day.net/
RServ (seems a bit out-of-date):
http://techdocs.postgresql.org/techdocs/settinguprserv.php
Are these the one I should study and test first? Is
there some de facto method for simple PgSQL
replication/mirroring case I described above?
Any comments appreciated!
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Thorsten Haude | 2003-01-02 19:52:33 | Re: download postgresql for windows |
Previous Message | Tom Lane | 2003-01-01 19:30:31 | Re: localhost connects, same code on other host fails |