pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Connecting 2 databases within the same instance
Date: Fri, 13 Oct 2023 15:58:26 -0600
Message-ID: <7D811B62-FA0A-4A72-9AE6-343E6CC692AF@elevated-dev.com> (raw)
In-Reply-To: <DM4PR19MB597815380401626E1787AD49D3D2A@DM4PR19MB5978.namprd19.prod.outlook.com>
References: <PH2P110MB0922C926B5D471091BFD1304FFD2A@PH2P110MB0922.NAMP110.PROD.OUTLOOK.COM>
	<DM4PR19MB597815380401626E1787AD49D3D2A@DM4PR19MB5978.namprd19.prod.outlook.com>

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






view thread (9+ messages)  latest in thread

Message-ID: <7D811B62-FA0A-4A72-9AE6-343E6CC692AF@elevated-dev.com>
Permalink:  ../7D811B62-FA0A-4A72-9AE6-343E6CC692AF@elevated-dev.com/
Also on:    postgresql.org/message-id/7D811B62-FA0A-4A72-9AE6-343E6CC692AF@elevated-dev.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, sarwarmd02@outlook.com
  Subject: Re: Connecting 2 databases within the same instance
  In-Reply-To: <7D811B62-FA0A-4A72-9AE6-343E6CC692AF@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox