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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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