Re: access multiple PostgreSQL Databases at the same time.

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: access multiple PostgreSQL Databases at the same time.
Дата
Msg-id 20040324201910.GA16800@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на access multiple PostgreSQL Databases at the same time.  (Louie Kwan <lkwan@nuvo.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Louie Kwan
Дата:
Сообщение: access multiple PostgreSQL Databases at the same time.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [Retrieved]RE: backup and recovery