We use Postgres 7.0.3 to store data for our scientific research. We have
two other labs in St. Louis, MO and Tempe, AZ. I'd like to see if
there's a way for them to mirror our database. They would be able to
update our database when they received new results and we would be able
to update theirs. So, in effect, we'd have 3 copies of the same db. Each
copy would be able to update the other.

Any thoughts on if this is possible?

Thanks.
-Tony Reina



Fri, 20 Apr 2001 15:33:38 -0700
"G. Anthony Reina" <reina@nsi.edu>
Is it possible to mirror the db in Postgres?
On Fri, Apr 20, 2001 at 03:33:38PM -0700, G. Anthony Reina wrote:
> We use Postgres 7.0.3 to store data for our scientific research. We have
> two other labs in St. Louis, MO and Tempe, AZ. I'd like to see if
> there's a way for them to mirror our database. They would be able to
> update our database when they received new results and we would be able
> to update theirs. So, in effect, we'd have 3 copies of the same db. Each
> copy would be able to update the other.
> 
> Any thoughts on if this is possible?

Does the replication have to be reliable?  Are you equipped to
reconcile databases that have got out of sync, if not?  Will the
different labs ever try to update the same existing record, or
insert conflicting (unique-key) records?

Symmetric replication is easy or impossible, but usually somewhere 
in between, depending on many details.  Usually when it's made to
work, it runs on a LAN.  

Reliable WAN replication is harder.  Most of the proprietary database 
companies will tell you they can do it, but their customers will tell 
you they can't.  

Nathan Myers
ncm@zembu.com

Fri, 20 Apr 2001 15:56:34 -0700
ncm@zembu.com (Nathan Myers)
Re: Is it possible to mirror the db in Postgres?
> Reliable WAN replication is harder.  Most of the proprietary database 
> companies will tell you they can do it, but their customers will tell 
> you they can't.  

This comment is great.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 20 Apr 2001 19:16:09 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Is it possible to mirror the db in Postgres?