Skip site navigation (1) Skip section navigation (2)

Re: Connection to second database on server

From: Troy Rasiah <troyr(at)vicnet(dot)net(dot)au>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, troyrasiah(at)gmail(dot)com
Subject: Re: Connection to second database on server
Date: 2008-08-25 04:19:54
Message-ID: 48B232EA.20703@vicnet.net.au (view raw or flat)
Thread:
Lists: pgsql-general

Scott Marlowe wrote:
> On Sun, Aug 24, 2008 at 8:43 PM, Troy Rasiah <troyr(at)vicnet(dot)net(dot)au> wrote:
>> Sorry for bringing up an old post...If you have a generic set of tables..
>>
>> eg. table of countries / post codes etc which are used across several
>> databases what is the best way to access / store them?
>> I currently
>>  - use dblink to create views when i want to do joins,
>>  OR
>>  - i just open up a separate db handle when i just want to display the
>> data (via a perl script) from the 'generic database' (eg. a select list
>> of countries)
>>
>> but was wondering whether schema's would apply to me as well ?
> 
> Yes, schemas would be much better.  The nice thing is with
> search_path, you could have a setup where application1 and
> application2 live in different schemas but have access to a common
> schema.  When running app1, you'd do something like:
> 
> set search_path='app1','commonschema';
> 
> and when running app2 you'd change the app1 up there to app2 and then
> you could access the tables in both schemas without having to use
> prefixes.


Thanks Scott. We currently do websites for different customers on the
same machine so we have been setting each of them up with individual
(database,user,pass).

Instead should i be setting them all up in the one database and having
individual schema's for each customer and then only granting each user
access to their schema & the proposed 'commonschema' ?

-- 
Troy Rasiah

In response to

Responses

pgsql-general by date

Next:From: Ow Mun HengDate: 2008-08-25 04:23:03
Subject: Issue with creation of Partial_indexes (Immutable?)
Previous:From: Scott MarloweDate: 2008-08-25 03:59:08
Subject: Re: Connection to second database on server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group