Replication

From: "Mihai Gheorghiu" <tanethq(at)earthlink(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Replication
Date: 2001-11-15 19:14:23
Message-ID: 005301c16e09$bd0ea860$6e646464@New6.Travel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I checked gborg.postgresql.org, but I'm still not clear about the following:
I have a configuration that backs-up the database on server A every night
and the file is stored on server B (200 miles away, over a T1). Upon
arrival, the db is restored on server B, so, in the morning, A and B are
identical.
The working server is A. Users at location B actually use server A over T1
for normal operations.
If the T1 fails (assume overnight, after backup was transmitted), users at
the two ends can work off the local server.
If PG was installed without replication support, is there a way to
synchronize the two databases after each end has made changes to them?
Thank you all.

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2001-11-15 19:29:48 Re: UPDATE w/ subselect doing locking
Previous Message Andrew G. Hammond 2001-11-15 19:13:43 Re: Modifying check constraints