Обсуждение: Connecting 2 databases within the same instance

> On Oct 13, 2023, at 3:53 PM, M Sarwar <sarwarmd02@outlook.com> wrote:
>
>
>   Hello,
>   I have one instance and two database within it. What is the simplest approach which I can adopt to connect these 2
databaseto one another. 
> I want to have the ability to connect to any table. For example database link in Oracle databases. How can I deploy
thisgracefully? 
>  Thanks,
> Sarwar

maybe: https://www.postgresql.org/docs/current/postgres-fdw.html

dblink is an older way to access external databases, in general I'd prefer FDW

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/



> 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 ?
>

Hi,

Are you saying that Db Link is existing in the Postgress or just referring to FDW ?

Sarwar

Sent from my Galaxy

-------- Original message --------

From: swastik Gurung <gurung_swastik@yahoo.com>

Date: 10/13/23 9:37 PM (GMT-05:00)

To: pgsql-admin@postgresql.org, M Sarwar <sarwarmd02@outlook.com>

Subject: Re: Connecting 2 databases within the same instance

I think any of the two contrib module dblink and/or postgres_fdw could help

On Saturday, 14 October 2023 at 03:38:33 GMT+5:45, M Sarwar <sarwarmd02@outlook.com> wrote:

#yiv3643911366 p {margin-top:0; margin-bottom:0}

 

 

Hello,

 

 I have one instance and two database within it. What is the simplest approach which I can adopt to connect these 2 database to one another.

I want to have the ability to connect to any table. For example database link in Oracle databases. How can I deploy this gracefully?

 

Thanks,

Sarwar