From: swastik Gurung <gurung_swastik@yahoo.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
To: M Sarwar <sarwarmd02@outlook.com>
Subject: Re: Connecting 2 databases within the same instance
Date: Sat, 14 Oct 2023 01:37:00 +0000 (UTC)
Message-ID: <1546706033.6267226.1697247420904@mail.yahoo.com> (raw)
In-Reply-To: <DM4PR19MB597815380401626E1787AD49D3D2A@DM4PR19MB5978.namprd19.prod.outlook.com>
References: <PH2P110MB0922C926B5D471091BFD1304FFD2A@PH2P110MB0922.NAMP110.PROD.OUTLOOK.COM>
<DM4PR19MB597815380401626E1787AD49D3D2A@DM4PR19MB5978.namprd19.prod.outlook.com>
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
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: gurung_swastik@yahoo.com, sarwarmd02@outlook.com
Subject: Re: Connecting 2 databases within the same instance
In-Reply-To: <1546706033.6267226.1697247420904@mail.yahoo.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