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@xxxxxxxxx> 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
Attachment:
signature.asc
Description: Digital signature
