Re: Connecting 2 databases within the same instance

From: swastik Gurung <gurung_swastik(at)yahoo(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, M Sarwar <sarwarmd02(at)outlook(dot)com>
Subject: Re: Connecting 2 databases within the same instance
Date: 2023-10-14 01:37:00
Message-ID: 1546706033.6267226.1697247420904@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)outlook(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message M Sarwar 2023-10-14 01:40:54 RE: Connecting 2 databases within the same instance
Previous Message Tom Lane 2023-10-13 22:39:33 Re: One PG process eating more than 40GB of RAM and getting killed by OOM