From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | John R Pierce <pierce(at)hogranch(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Database Design Question |
Date: | 2011-02-02 19:59:18 |
Message-ID: | 20110202195917.GA5020@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Feb 02, 2011 at 11:44:51AM -0800, John R Pierce wrote:
> On 02/02/11 11:24 AM, Joshua D. Drake wrote:
>> Forget separate databases. Use separate users with schemas.
>
> for canned applications like mediawiki and phpbb? not sure they
> support that.
>
If they use different users you can easily do it by setting the default
search path per user.
ALTER USER phpbb SET search_path='phpbbschema';
As long as the apps don't play with the search path themselves it
should be fine.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patriotism is when love of your own people comes first; nationalism,
> when hate for people other than your own comes first.
> - Charles de Gaulle
From | Date | Subject | |
---|---|---|---|
Next Message | Vick Khera | 2011-02-02 20:16:28 | Re: Changing SHMMAX |
Previous Message | Gary Chambers | 2011-02-02 19:57:56 | Re: Database Design Question |