Replication

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

Browse pgsql-novice by date

  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