Re: Connecting 2 databases within the same instance
| От | M Sarwar |
|---|---|
| Тема | Re: Connecting 2 databases within the same instance |
| Дата | |
| Msg-id | DM4PR19MB5978FB39599CF191D606AB29D3D1A@DM4PR19MB5978.namprd19.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: Connecting 2 databases within the same instance (Scott Ribe <scott_ribe@elevated-dev.com>) |
| Список | pgsql-admin |
Hello Scott,
You have a solid point. I am coming onto Postgress environments for the last one year.
Thank you so much,
Sarwar
From: Scott Ribe <scott_ribe@elevated-dev.com>
Sent: Friday, October 13, 2023 10:08 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Connecting 2 databases within the same instance
Sent: Friday, October 13, 2023 10:08 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Connecting 2 databases within the same instance
dblink is an older way to access external databases, in general I'd prefer FDW
--
Scott Ribe
scott_ribe@elevated-dev.com
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fin%2Fscottribe%2F&data=05%7C01%7C%7C48c15f64f1b34b39d37508dbcc5a7ba6%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638328461215945939%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4lfbwFS8j6LznWFYX1G9PtR%2BHdXeb6KvqDph1JWxdaw%3D&reserved=0
> On Oct 13, 2023, at 7:40 PM, M Sarwar <sarwarmd02@outlook.com> wrote:
>
> Are you saying that Db Link is existing in the Postgress or just referring to FDW ?
>
--
Scott Ribe
scott_ribe@elevated-dev.com
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fin%2Fscottribe%2F&data=05%7C01%7C%7C48c15f64f1b34b39d37508dbcc5a7ba6%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638328461215945939%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=4lfbwFS8j6LznWFYX1G9PtR%2BHdXeb6KvqDph1JWxdaw%3D&reserved=0
> On Oct 13, 2023, at 7:40 PM, M Sarwar <sarwarmd02@outlook.com> wrote:
>
> Are you saying that Db Link is existing in the Postgress or just referring to FDW ?
>
В списке pgsql-admin по дате отправления: