Re: combining db's- importing primary keys - Mailing list pgsql-general

From Bob Gobeille
Subject Re: combining db's- importing primary keys
Date
Msg-id BA595900-6915-47DF-A6CA-85D515C57236@hp.com
Whole thread Raw
In response to Re: combining db's- importing primary keys  (nha <lyondif02@free.fr>)
Responses Re: combining db's- importing primary keys
Re: combining db's- importing primary keys
List pgsql-general
On Jul 29, 2009, at 8:26 AM, nha wrote:

> Hello,
>
> Le 29/07/09 15:02, Jasen Betts a écrit :
>> On 2009-07-27, Bob Gobeille <bob.gobeille@hp.com> wrote:
>>> I would like to combine multiple databases (same schema) into one
>>> master db.   Does anyone know how I can reconcile all my primary and
>>> foreign keys to maintain referential integrity.
>>
>> prefix them all with something that's unique to their source
>> database.
>>
>> easy to say, hard to do.
>>
>
> A process (and solution) may be different whether:
> -the master db will replace all other databases (ie. data manipulation
> would directly perform on data managed by master db);
> -or the master db will reflect a combined view of data hosted by all
> other databases (ie. data manipulation would still perform on
> distributed databases and master db would play a role of federated
> view);
> -or both (data manipulation have to be manageable at the both side: on
> master db and on distributed db).

In my immediate case, I'm simply combining 7 global databases into a
single master.

Eventually, I would like to allow our (fossology.org) users to
subscribe to data in other databases.  That is, allow
users to do periodic one-way batch updates from other servers.

Bob

pgsql-general by date:

Previous
From: Brodie Thiesfield
Date:
Subject: How to prevent duplicate key error when two processes do DELETE/INSERT simultaneously?
Next
From: Radek Novotný
Date:
Subject: integration of fulltext search in bytea/docs