Skip site navigation (1) Skip section navigation (2)

Re: do I need replication or something else?

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Caleb Simonyi-Gindele" <caleb(at)vetstar(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: do I need replication or something else?
Date: 2005-03-29 19:15:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
Sounds like you are begging for trouble.

Suppose that a customer calls in to the main office, and you update some
customer data.

The field salesman also updates data for this customer.

If you update the main office database with the field data, you will
lose information.

If you update the field database data with main office database data,
you will lose information.

Because we have two different changed records, it will be very difficult
to reconcile this data without human intervention.

In short, a disconnected system where data on both ends can change is
begging for trouble.

Now, if you never update the database in the main office except with
data from the field salesmen, it could be made to work.  But I doubt
that this is what you are after.

If it were me, and someone proposed a model where two-way replication
was needed, I would tell them to rethink their model.  It's broken.


-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Caleb
Sent: Tuesday, March 29, 2005 10:58 AM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] do I need replication or something else?

We have a billing system and we want the ability to send users out into 
the field with an unconnected (no WAN, VPN etc) laptop containing our pg

db and software. Upon their return we need to synchronize changes to the

main db. We would like the ability to be able to have this accomplished 
at the db level rather than doing this in our app.

What is the best tool to accomplish this with?


pgsql-general by date

Next:From: Oleg BartunovDate: 2005-03-29 19:52:57
Subject: Re: 8.0.1 in a non-standard location and tsearch2
Previous:From: Dave ChapeskieDate: 2005-03-29 19:10:17
Subject: btree index bloat, prototype non-locking solution

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group