X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 06E1BD1D8F3 for ; Wed, 24 Mar 2004 20:19:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 84314-09 for ; Wed, 24 Mar 2004 16:19:13 -0400 (AST) Received: from fep03-mail.bloor.is.net.cable.rogers.com (fep03-mail.bloor.is.net.cable.rogers.com [66.185.86.73]) by svr1.postgresql.org (Postfix) with ESMTP id CA4CED1BA8F for ; Wed, 24 Mar 2004 16:19:09 -0400 (AST) Received: from phlogiston.dydns.org ([65.49.121.67]) by fep03-mail.bloor.is.net.cable.rogers.com (InterMail vM.5.01.05.12 201-253-122-126-112-20020820) with ESMTP id <20040324201901.UHNP147578.fep03-mail.bloor.is.net.cable.rogers.com@phlogiston.dydns.org> for ; Wed, 24 Mar 2004 15:19:01 -0500 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 780DB3BEC; Wed, 24 Mar 2004 15:19:10 -0500 (EST) Date: Wed, 24 Mar 2004 15:19:10 -0500 From: Andrew Sullivan To: "'pgsql-admin@postgresql.org'" Subject: Re: access multiple PostgreSQL Databases at the same time. Message-ID: <20040324201910.GA16800@phlogiston.dyndns.org> Mail-Followup-To: "'pgsql-admin@postgresql.org'" References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.5.1+cvs20040105i X-Authentication-Info: Submitted using SMTP AUTH LOGIN at fep03-mail.bloor.is.net.cable.rogers.com from [65.49.121.67] using ID at Wed, 24 Mar 2004 15:19:01 -0500 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/319 X-Sequence-Number: 12888 On Wed, Mar 24, 2004 at 03:09:21PM -0500, Louie Kwan wrote: > Hi All, > > Due to some security issues, we need to separate the data for one customer > into a separate PostgreSQL box/server. > > My question is that how could we have sql statements which allow us to > access multiple PostgreSQL databases at the same time. Not separate schema, > but in different postgresql server. Doesn't seem like much security if you're going to break it by putting a back door in. But there's a contrib module called dblink that will likely help you. A -- Andrew Sullivan | ajs@crankycanuck.ca The plural of anecdote is not data. --Roger Brinner