Home > mailing lists

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

From	M Sarwar
Subject	Connecting 2 databases within the same instance
Date	October 13, 2023 21:53:16
Msg-id	DM4PR19MB597815380401626E1787AD49D3D2A@DM4PR19MB5978.namprd19.prod.outlook.com Whole thread Raw
Responses	Re: Connecting 2 databases within the same instance Re: Connecting 2 databases within the same instance
List	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

From: Tom Lane
Date: 13 October 2023, 19:38:43
Subject: Re: One PG process eating more than 40GB of RAM and getting killed by OOM

From: Scott Ribe
Date: 13 October 2023, 21:58:26
Subject: Re: Connecting 2 databases within the same instance