pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedaccess multiple PostgreSQL Databases at the same time.
2+ messages / 2 participants
[nested] [flat]
* access multiple PostgreSQL Databases at the same time.
@ 2004-03-24 20:09 Louie Kwan <lkwan@nuvo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Louie Kwan @ 2004-03-24 20:09 UTC (permalink / raw)
To: pgsql-admin
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.
Is there a way to SELECT tables or create JOINs from multiple databases JDBC
or psql . I aware that Oracle has Database Link concept.
Any tip will help. I did some search on previous posting, but cannot find
much.
Louie Kwan
> NUVO - THE IT OUT-TASKING COMPANY
> (613) 726-5071 Direct Line
> (613) 721-1399 Fax
>
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: access multiple PostgreSQL Databases at the same time.
@ 2004-03-24 20:19 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Louie Kwan <lkwan@nuvo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Andrew Sullivan @ 2004-03-24 20:19 UTC (permalink / raw)
To: 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@crankycanuck.ca
The plural of anecdote is not data.
--Roger Brinner
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-03-24 20:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-24 20:09 access multiple PostgreSQL Databases at the same time. Louie Kwan <lkwan@nuvo.com>
2004-03-24 20:19 ` Andrew Sullivan <ajs@crankycanuck.ca>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox