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

Re: access multiple PostgreSQL Databases at the same time.

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: access multiple PostgreSQL Databases at the same time.
Date: 2004-03-24 20:19:10
Message-ID: 20040324201910.GA16800@phlogiston.dyndns.org (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)crankycanuck(dot)ca
The plural of anecdote is not data.
		--Roger Brinner

In response to

pgsql-admin by date

Next:From: Christopher BrowneDate: 2004-03-24 21:09:05
Subject: Re: [PHP] upgrading to 7.4.2
Previous:From: Louie KwanDate: 2004-03-24 20:09:21
Subject: access multiple PostgreSQL Databases at the same time.

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