Connecting 2 databases within the same instance

From: M Sarwar <sarwarmd02(at)outlook(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Connecting 2 databases within the same instance
Date: 2023-10-13 21:53:16
Message-ID: DM4PR19MB597815380401626E1787AD49D3D2A@DM4PR19MB5978.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2023-10-13 21:58:26 Re: Connecting 2 databases within the same instance
Previous Message Tom Lane 2023-10-13 19:38:43 Re: One PG process eating more than 40GB of RAM and getting killed by OOM