Postgres Pro
Downloads
Home   >   mailing lists

Re: Connecting 2 databases within the same instance - Mailing list pgsql-admin

From swastik Gurung
Subject Re: Connecting 2 databases within the same instance
Date
Msg-id 1546706033.6267226.1697247420904@mail.yahoo.com
Whole thread Raw
In response to Connecting 2 databases within the same instance  (M Sarwar <sarwarmd02@outlook.com>)
Responses RE: Connecting 2 databases within the same instance
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: One PG process eating more than 40GB of RAM and getting killed by OOM
Next
From: M Sarwar
Date:
Subject: RE: Connecting 2 databases within the same instance