Re: Connecting 2 databases within the same instance

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Connecting 2 databases within the same instance
Date: 2023-10-13 21:58:26
Message-ID: 7D811B62-FA0A-4A72-9AE6-343E6CC692AF@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Oct 13, 2023, at 3:53 PM, M Sarwar <sarwarmd02(at)outlook(dot)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 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

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message M Sarwar 2023-10-13 22:36:58 Re: Connecting 2 databases within the same instance
Previous Message M Sarwar 2023-10-13 21:53:16 Connecting 2 databases within the same instance