Bob, Thanks for the suggestions....
I believe your 3rd suggestion is what I'm leaning toward --- I have asked each product team to do a pg_dump to archive the database.... would be nice to then 'import/combine' them into a central database.... Thanks, Tom Murray Senior Systems Engineer Eastman Kodak Company Bob Gobeille <[email protected]> 07/27/2009 12:44 PM To "[email protected]" <[email protected]> cc "[email protected]" <[email protected]> Subject Re: [FOSSology] Combining databases from several servers On Jul 27, 2009, at 9:31 AM, [email protected] wrote: Hello all, Our company is attempting to scan/analyze all of our product software. Many locations throughout the world, some product teams are reluctant to use our central Fossology server so they have setup their own, So we have approximately 7 separate servers collecting OSS info..... I'd like to aggregate all the various server data into one database so that it can be viewed via the Fossology UI (or other means)...... any ideas on how to do this? Hello Thomas, There are three things to keep track of: 1) UI (this step is unnecessary if you do 3. below) the UI can handle a split repository, but not a split database. You could change each UI plugin to query the multiple databases and aggregate the results. 2) Split repository If each repository could be nfs mounted to each other, then Hosts.conf could specify them all. If any file in the DB can't be found in host/repository 1, then it would look in host/repository 2, ... 3) Database (this is unnecessary if you do 1. above) Each site could share the same (replicated, or synched) database. The problem is how to combine the multiple databases without breaking referential integrity. I've asked the postgresql list for some help with this because it seems crazy that this hasn't already been addressed. Bob
_______________________________________________ fossology mailing list [email protected] http://fossology.org/mailman/listinfo/fossology
