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

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: (view raw, whole thread or download thread mbox)
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:



In response to


pgsql-novice by date

Next:From: BenjaminDate: 2004-09-22 12:34:02
Subject: max_connections not changing
Previous:From: Jonathon BatsonDate: 2004-09-22 03:17:07
Subject: Multi Database queries

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