Re: combining db's- importing primary keys

From: Chris <dmagick(at)gmail(dot)com>
To: Bob Gobeille <bob(dot)gobeille(at)hp(dot)com>
Cc: nha <lyondif02(at)free(dot)fr>, PgSQL-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: combining db's- importing primary keys
Date: 2009-07-29 23:13:50
Message-ID: 4A70D7AE.5060201@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris wrote:
> Bob Gobeille wrote:
>>
>> 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(dot)gobeille(at)hp(dot)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.
>
> Have you thought about schemas?
>
> You can set up different users with different search paths so all the
> data's in one spot, and getting to another schema is easy enough. No
> changes necessary to the data itself, just the calling code.

Blah, ignore - I didn't read your first email properly :P

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2009-07-29 23:36:59 Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'
Previous Message Chris 2009-07-29 23:12:27 Re: combining db's- importing primary keys