Re: Some thoughts on replication - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Some thoughts on replication
Date
Msg-id 200101271812.NAA11578@candle.pha.pa.us
Whole thread Raw
In response to Re: Some thoughts on replication  (Dirk Heinrichs <heini@chaos.tng.oche.de>)
List pgsql-admin
> Am Samstag, 27. Januar 2001 00:20 schrieb Bruce Momjian:
> > > Have you looked at the replication code that is in contrib?
> >
> > Yes, your description sounds just like it.
>
> Hmm, which of the two? The trigger mechanism?

The triggers.

>
> In the meantime, a third solution came to my mind:
>
> In case somebody has to take a database with him on a laptop, it is hard to
> do replication and avoid conflicts. I once saw an insurance application,
> based on FoxPro, where the insurance agents could select the data of the
> customers he wanted to visit and and create a so called child database, which
> had exactly he same tables as the "mother" and exactly those rows with data
> related to the selected customers. Those rows where the marked as readonly in
> the mother database, so that only the data in the child db could be changed.
> Later, the changes in th child db was reintegrated into the mother db and the
> child was deleted.

Yes, that is a data partitioning feature of replication.
--
  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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: postgres limitation
Next
From: Michael Davis
Date:
Subject: RE: Admin tutorials?