Re: Re: Is it possible to mirror the db in Postgres?

From: Ryan Mahoney <ryan(at)paymentalliance(dot)net>
To: pgsql-hackers(at)postgreSQL(dot)org, pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Re: Is it possible to mirror the db in Postgres?
Date: 2001-04-20 20:45:52
Message-ID: 5.0.2.1.0.20010420214243.025eec50@paymentalliance.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

You probably already thought of this - but - why not just set up a
centralized server and have each office interact to the db via a web
interface. Let your application enforce security (apacheSSL, use db for
user auth) and to prevent two users from editing the same record
simultaneously.

-r

At 06:19 PM 4/20/01 -0700, Nathan Myers wrote:

>On Fri, Apr 20, 2001 at 04:53:43PM -0700, G. Anthony Reina wrote:
> > Nathan Myers wrote:
> >
> > > Does the replication have to be reliable? Are you equipped to
> > > reconcile databases that have got out of sync, when it's not?
> > > Will the different labs ever try to update the same existing
> > > record, or insert conflicting (unique-key) records?
> >
> > (1) Yes, of course. (2) Willing--yes; equipped--dunno. (3) Yes,
> > probably.
>
>Hmm, good luck. Replication, by itself, is not hard, but it's only
>a tiny part of the job. Most of the job is in handling failures
>and conflicts correctly, for some (usually enormous) definition of
>"correctly".
>
> > > 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.
> >
> > Joel Burton suggested the rserv utility. I don't know how well it would
> > work over a wide network.
>
>The point about WANs is that things which work nicely in the lab, on a
>LAN, behave very differently when the communication medium is, like the
>Internet, only fitfully reliable. You will tend to have events occurring
>in unexpected order, and communications lost, and queues topping over,
>and conflicting entries in different instances which you must somehow
>reconcile after the fact. Reconciliation by shipping the whole database
>across the WAN is often impractical, particularly when you're trying to
>use it at the same time.
>
>WAN replication is an important part of Zembu's business, and it's hard.
>I would expect the rserv utility (about which I admit I know little) not
>to have been designed for the job.
>
>Nathan Myers
>ncm(at)zembu(dot)com
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com)
>Version: 6.0.250 / Virus Database: 123 - Release Date: 4/18/01

Attachment Content-Type Size
unknown_filename text/plain 166 bytes

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message G. Anthony Reina 2001-04-20 22:33:38 Is it possible to mirror the db in Postgres?
Previous Message Thomas Lockhart 2001-04-20 19:52:16 Re: Docs on web site