pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mihai Gheorghiu <tanethq@earthlink.net>
To: pgsql-general@postgresql.org
Subject: Replication
Date: Thu, 15 Nov 2001 14:14:23 -0500
Message-ID: <005301c16e09$bd0ea860$6e646464@New6.Travel> (raw)

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.




view thread (131+ messages)  latest in thread

Message-ID: <005301c16e09$bd0ea860$6e646464@New6.Travel>
Permalink:  ../005301c16e09$bd0ea860$6e646464@New6.Travel/
Also on:    postgresql.org/message-id/005301c16e09$bd0ea860$6e646464@New6.Travel

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: tanethq@earthlink.net
  Subject: Re: Replication
  In-Reply-To: <005301c16e09$bd0ea860$6e646464@New6.Travel>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox