pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
access 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