Re: Multi Database queries

From: Joe Conway <mail(at)joeconway(dot)com>
To: jonathon(at)octahedron(dot)com(dot)au
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Multi Database queries
Date: 2004-09-22 03:48:49
Message-ID: 4150F621.6050502@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

HTH,

Joe

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Benjamin 2004-09-22 12:34:02 max_connections not changing
Previous Message Jonathon Batson 2004-09-22 03:17:07 Multi Database queries