Search Postgresql Archives

Re: Sharing static data among several databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Robert James" <srobertjames@xxxxxxxxx> writes:

> 1.) Is there a way of separating, isolating, and sharing the shared data that
> will still allow FKs to it?

The only approach I know of would be to make all your customers use
independent schemas in one database, with isolation via appropriate
permissions, and have your shared data in another schema that all the
users have read access to.  Each user could have a search_path that
contained their schema and the shared schema, which should minimize
the amount of query-changing you'd need to do.

Note that this is basically what you would do with Oracle--it doesn't
have a concept of "database" really, just an "instance" that contains
schemas (which map more-or-less onto database users).

It would certainly be a change in your architecture, but how much work
it would be I don't know...

-Doug

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux