Received: from scaup.prod.itd.earthlink.net (scaup.mail.pas.earthlink.net
	[207.217.120.49])
	by postgresql.org (8.11.3/8.11.4) with ESMTP id fAFJAem27420
	for <pgsql-general@postgresql.org>;
	Thu, 15 Nov 2001 14:10:40 -0500 (EST)
	(envelope-from tanethq@earthlink.net)
Received: from user-2ivet1a.dialup.mindspring.com ([165.247.116.42] helo=New6)
	by scaup.prod.itd.earthlink.net with smtp (Exim 3.33 #1)
	id 164RuJ-0001Vp-00
	for pgsql-general@postgresql.org; Thu, 15 Nov 2001 11:10:39 -0800
Message-ID: <005301c16e09$bd0ea860$6e646464@New6.Travel>
From: "Mihai Gheorghiu" <tanethq@earthlink.net>
To: <pgsql-general@postgresql.org>
Subject: Replication
Date: Thu, 15 Nov 2001 14:14:23 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Archive-Number: 200111/592
X-Sequence-Number: 17587

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.