From: | Igor Korot <ikorot01(at)gmail(dot)com> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Attaching database |
Date: | 2020-10-19 18:18:20 |
Message-ID: | CA+FnnTx-xCQ1=tiU_U734UyAeNhM_AHyWk9ZX9a3DGWhDfKesA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, Pavel,
On Mon, Oct 19, 2020 at 12:51 PM Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>
> Hi
>
> po 19. 10. 2020 v 19:40 odesílatel Igor Korot <ikorot01(at)gmail(dot)com> napsal:
>>
>> Hi,
>> IIUC, PostgreSQL does not support attaching a database to an existing
>> connection.
>> However I was told that I can use this:
>> https://www.postgresql.org/docs/9.3/postgres-fdw.html.
>>
>> Is it the same thing? Why there is no simple
>>
>> ATTACH <db> AS <dbname>
>>
>
> It is a different thing - postgresql_fdw does nested connect - it uses client-server protocol.
>
> For postgres connect and sql engine process is one entity - and engine is written without a possibility to reconnect to another database.
So if I understand correctly the postgresql_fdw is creating a second
connection and uses it as kind of "virtualizing mechanism"
in order to give access to the second database.
Am I right?
Thank you.
>
> Regards
>
> Pavel
>
>
>
>>
>> ?
>>
>> Thank you.
>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2020-10-19 18:21:05 | Re: Attaching database |
Previous Message | Pavel Stehule | 2020-10-19 17:50:31 | Re: Attaching database |