Re: Multi Database queries

Joe Conway wrote:

> Jonathon Batson wrote:
>
>> I am looking into setting up a multi-database system with Postgres7.3.4.
>> In this case all the databases will be on the one server.
>> Initial research shows that the contrib/dblink module is needed....
>> My question is:
>>    Is this the only way to query across databases?
>
>
> Yes, but, if your databases are all on one server under one postmaster
> you should consider using one database with multiple schemas. See:
>   http://www.postgresql.org/docs/current/static/sql-createschema.html

We're using this for one of our projects and it really works well.
Initially we had separate databases and queried them using dblink, but
for our purposes multiple schemas works much better, and cross schema
queries are as simple as any other queries. BTW if you are looking at
setting up a new system, why not use 7.4.5 (or whatever the latest
stable version is)?

Ron

>
> HTH,
>
> Joe
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
>