Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qrTbZ-004Slj-8s
	for pgsql-admin@arkaria.postgresql.org; Sat, 14 Oct 2023 01:38:13 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qrTaY-0054r7-0w
	for pgsql-admin@arkaria.postgresql.org; Sat, 14 Oct 2023 01:37:10 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <gurung_swastik@yahoo.com>)
	id 1qrTaW-0054o1-VK
	for pgsql-admin@lists.postgresql.org; Sat, 14 Oct 2023 01:37:10 +0000
Received: from sonic314-20.consmr.mail.gq1.yahoo.com ([98.137.69.83])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <gurung_swastik@yahoo.com>)
	id 1qrTaU-000NMV-C1
	for pgsql-admin@postgresql.org; Sat, 14 Oct 2023 01:37:07 +0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048;
 t=1697247423; bh=PPZQC3NTUYkLHacnHoherIhMtd+CcpYS19mXcFw/AX0=;
 h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To;
 b=h7TZ9qdXMWE1DIUY2QtTQYsLbqC++ZmU61EOSYWDA/DIPpNXpgirZMcdH8l+tzAn+gJAizWnD8fagEp8XWZsIKRRkWNhL8wZbf7DjlcswkdZ7bjUOd8s7CYXhv3hQj6ca80UjT3LAVb/2bV/DROLyhBo5TkJVCRgJ2Tt3kiP01sVOg89SAwUCubMuIcukNh1O0Q/KpEfDNYFWE/s3eRmBZlB8sDhOY9Bv4LbsqZco4mVxCnndVOxsrW+QcEchSuq/x9d+5K2og9WVuiNvB2/trtxlxR1D+tMNCLczFjxxge9mn58aicG9MDtx+WaoF8MCMKKqnG8k6ZESOLu1HsiIA==
X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048;
 t=1697247423; bh=dLfjKN/+ZV5wsRhnIZCPSNZcV8GHpoTl6OTbzP7toIc=;
 h=X-Sonic-MF:Date:From:To:Subject:From:Subject;
 b=nr5CThZk5LPvRVP2+CSdXbvIJhPDtt4esQp+RHwLhIYOEnTzNVoeEAcf8UImvndhfmvXl1DWplUHvNEBtJfpRNdao2RvxrAgqBaX5o08qq35+E11rgQ6pBMkmcQB0okljkvfZd5umBrTy4BV+47d2TQ7G6uQZGYN6FDY18gaUiI3EAVn9OJhkY4ocBUnnY0lydzcS89KYKEOj3m8OFIaijFU/Lon/v0kCTuTbaZjEJRm1XKSRkCFmNG43qFWthCuwVX6sK9WNlFGtFZ9nEurvhErVJAvf20+oBh7q612Ukxtr0oTE4W+nihiejwCovkJwRFVtOrGDlfoBrZlySlhFw==
X-YMail-OSG: xh16hz8VM1l7mV9lckX3h6XXQu4E6PipzEj4QgXlRRJUiEUhzZzAoVP0204KZvz
 SpVYcb0hDF5yW4tHpZJIoCVAigOrxD.LBjQsWrB2G_McALWJ34QMIcilbFy6em_2MDlsOE2ReaDo
 3bYuApfuMHkWUrXjGEj6KWOSwm4AfoMcbMX3xcZ.oyjaq9uHYE4UnQ3EYEBY17cR9SV_cHYh3ErM
 oO8cJVCjo3YNvWK9dPoJcznha8e10ilNcipqAOJhhnOBexTWSO8XnxwpUBiCCs1rmRwee7ju_teT
 KSQGE28cjlt4UzdwynngUJnuQhvL9xJ8ZYwz6qoqTiuozpCNkhRLKA.iHaHI.jrhjWavZFO5agmM
 1ZQFOGoJK0g2.3BabrBX4MRHrlkSYj4ZeQSaaELtV8XEmLRgzC8Vk92GaTY5Qom4E1pNPCN3Om2I
 EZFVI2gQ0y9sR7zs6nLoTqJ1xWqMtN7_BOrsM8DYTzgRjowMYzOskQv5NuiS5jxMc8etGGDgnpGM
 bqOEF6YQBTsPLN.U7KRczGD1zfahioR33nOB6YES1WugWE5x5uZFt.Hfe718H4arXXwBAoL9dr5z
 Vem841T.YIAOdC.9W8iSFEkhZlkx3yJfLWpV5V060KMlNWpvDcWbYIUSl1llQIJ1P0oe3F2dQ9Ye
 EPz2mOBZh1VwhO878z7h5lxXSrQD9HJkl.aUpWyYGDpwwf2Unl7qNKrAExFdlWohl3D0.QwLgKxW
 nsaawh.BypQi1augExg7OQDfXXFPAEM42qB9vaWHNgEVxenmRu6Vn5xnqk6AWxK65rkQegcUFmNu
 K5CgqcZ2z7LsheIgI4ARclu8t.LqpaPj80InpY7yy_gJ7u9kGr3noa.TIZZBrvQ8fZY4VVtffnVv
 ITjNvp0CJ76yjhHwfTwnTkwfZPGkpfKwHFZJEyk7aR4hES4hmIOHcU7xmCmP8qij7PkFQRFRQ8Np
 AuKUVmLyhy23q1nz9XAvEx02oFExjSxn3psQvdGCIXJqyVlpQD_xaDi87gEZ1hpR...wem2wP4Y9
 FsTlS3H6SH771yD__dgtULdMdhEEcBz1pwWijlP7_e4U6BN5cDZxSidvPCGOC5gCFUfl8xjLsknz
 zIfJpUfa_7ovwqOv_rM1QsGjkxByZ2qRX6nXbOPGjzjJbk56XJZYZDLaKOi2vwSn7eYP.rh72eI8
 fUcvHtJunk6BGRcdIoclgiU63PRLENHNAm7V3_VbrUPqmgHbsqw3_2sn61w8draWvnEij_5Kpftr
 neBBXBI6ZqBUgrLOGXcwxJlVskPLWDXq42n2k_XkmfblRXVykWh.WFRkUUEL_ztbybs03Npv9Jxb
 z1xH5N_.Z9sjor3hoL5gmi3rVsL4l2FdUTwOcaPOpBSEliB9PU_SJsIDWY094MT0Xbn8QYAUFUBv
 AaCu.WJu10EcTDTqNQY.ilNGRTFYGGn0SxyrLd4O63Yd_Z.eFUxZUkwsDn9MAuIFHzFu_Ue6N7jJ
 CC18Z_eLvatTjPAtVuhP.0qQ.6XdnzZ8G6gC4iwg_mI.Ww2pkQINsqHCvrkIWs.pt4iohuNMmQVR
 GaIt4T6mZWhaVf2lsT45h8o8Nu5H4ks8CuHVdcO8oBppnk6UxQ63Mbc6cxhwKtqSvhANsbwtdItD
 G6zRQZDXcpk0pFVz.DEhNoFQlJgAJhxUW9AvJHCkvD8xrQLHMeiXQg8fOy7lvhj2jlo.fH2TtsRA
 qeuai_JLkifZN9o38KNchhiU0J7SGme8AcAIRUZSIdpT31kV8yp7lS5dyR53trIxGWHUSqOZQ_AS
 1_sm6UKwQQTNOUb9jgn_wzi.S6l3kYcH7kSTZigNCz8YT2TO9di9FeitXz3OBxgUIFCXrrTOPP53
 .wLMoPVRFMWHWNC.2sf243qXXt0sT4NL_7x2ZYaRkiDu1Y.5etRQ27GwX1qhV4QLu1L_PwbDurmX
 C5P2YMD0D3Bw8G8qVgZlmyuvpZVjRS5zc7blIwlGNPOFRnVH1utYx1ErO8lI4TNmpIE_8tVIu6dO
 mDJWjmD_hXS5jrwquXjrfuSMPzNdOrVsF2vEqsYCIwjZWijDUHW80v3V8owR3HAhEFzP46npZwEv
 RMrwREGETHKj8DdCF27AmXvNmI.gfhleVkf6QTNGzOjivpv_C.VVxSAqFtne6dBI9nOQ.pAIm3kl
 2gtfvszSy13smzzCoyXqscdmcl33VtjNImAsiiVJKbspdY0EcNdf1sR1.4lR2RnIruKiMvr8cc.e
 sszOBbiIYbK8_MYcZr6733axuCZ_H4nA-
X-Sonic-MF: <gurung_swastik@yahoo.com>
X-Sonic-ID: 2dc0a996-3aaa-44a2-96cb-4d5d2f7334ad
Received: from sonic.gate.mail.ne1.yahoo.com by
 sonic314.consmr.mail.gq1.yahoo.com with HTTP; Sat, 14 Oct 2023 01:37:03 +0000
Date: Sat, 14 Oct 2023 01:37:00 +0000 (UTC)
From: swastik Gurung <gurung_swastik@yahoo.com>
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>,
	M Sarwar <sarwarmd02@outlook.com>
Message-ID: <1546706033.6267226.1697247420904@mail.yahoo.com>
In-Reply-To: 
 <DM4PR19MB597815380401626E1787AD49D3D2A@DM4PR19MB5978.namprd19.prod.outlook.com>
References: 
 <PH2P110MB0922C926B5D471091BFD1304FFD2A@PH2P110MB0922.NAMP110.PROD.OUTLOOK.COM>
 <DM4PR19MB597815380401626E1787AD49D3D2A@DM4PR19MB5978.namprd19.prod.outlook.com>
Subject: Re: Connecting 2 databases within the same instance
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_6267225_1396007580.1697247420902"
X-Mailer: WebService/1.1.21797 YMailNorrin
Content-Length: 4050
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/1546706033.6267226.1697247420904%40mail.yahoo.com>
Precedence: bulk

------=_Part_6267225_1396007580.1697247420902
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 I think any of the two contrib module dblink and/or postgres_fdw could hel=
p    On Saturday, 14 October 2023 at 03:38:33 GMT+5:45, M Sarwar <sarwarmd0=
2@outlook.com> wrote: =20
=20
  #yiv3643911366 P {margin-top:0;margin-bottom:0;}

=C2=A0

=C2=A0

Hello,

=C2=A0

=C2=A0I 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 li=
nk in Oracle databases. How can I deploy this gracefully?

=C2=A0

Thanks,

Sarwar
 =20
------=_Part_6267225_1396007580.1697247420902
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<html><head></head><body><div class="ydp93e398aeyahoo-style-wrap" style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:13px;"><div></div>
        <div dir="ltr" data-setdir="false">I think any of the two contrib module dblink and/or postgres_fdw could help</div>
        
        </div><div id="yahoo_quoted_7533804905" class="yahoo_quoted">
            <div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
                
                <div>
                    On Saturday, 14 October 2023 at 03:38:33 GMT+5:45, M Sarwar &lt;sarwarmd02@outlook.com&gt; wrote:
                </div>
                <div><br></div>
                <div><br></div>
                <div><div id="yiv3643911366">

 
<style type="text/css">#yiv3643911366 P {margin-top:0;margin-bottom:0;}</style>

<div dir="ltr">
<div style="font-family:Calibri, Helvetica, sans-serif;font-size:12pt;color:rgb(0, 0, 0);" class="yiv3643911366elementToProof">
<br>
</div>
<div lang="EN-US" style="word-wrap:break-word;">
<div class="yiv3643911366x_WordSection1">
<p style="margin:0in;font-size:11pt;font-family:Calibri, sans-serif;" class="yiv3643911366x_MsoNormal">
&nbsp;</p>
<p style="margin:0in;font-size:11pt;font-family:Calibri, sans-serif;" class="yiv3643911366x_MsoNormal">
&nbsp;</p>
<p style="margin:0in;font-size:11pt;font-family:Calibri, sans-serif;" class="yiv3643911366x_MsoNormal">
<span style="font-size:10.5pt;font-family:Roboto;background:white;color:rgb(22, 25, 31);">Hello,</span></p>
<p style="margin:0in;font-size:11pt;font-family:Calibri, sans-serif;" class="yiv3643911366x_MsoNormal">
<span style="font-size:10.5pt;font-family:Roboto;background:white;color:rgb(22, 25, 31);">&nbsp;</span></p>
<p style="margin:0in;font-size:11pt;font-family:Calibri, sans-serif;" class="yiv3643911366x_MsoNormal yiv3643911366elementToProof">
<span style="font-size:10.5pt;font-family:Roboto;background:white;color:rgb(22, 25, 31);">&nbsp;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.
</span></p>
<p style="margin:0in;" class="yiv3643911366x_MsoNormal yiv3643911366elementToProof"><font face="Roboto" style="color:rgb(22, 25, 31);"><span style="font-size:14px;">I want to have the ability to connect to any table. For example database link in Oracle databases. How can I deploy
 this gracefully?</span></font></p>
<p style="margin:0in;font-size:11pt;font-family:Calibri, sans-serif;" class="yiv3643911366x_MsoNormal">
<span style="font-size:10.5pt;font-family:Roboto;background:white;color:rgb(22, 25, 31);">&nbsp;</span></p>
<p style="margin:0in;font-size:11pt;font-family:Calibri, sans-serif;" class="yiv3643911366x_MsoNormal">
<span style="font-size:10.5pt;font-family:Roboto;background:white;color:rgb(22, 25, 31);">Thanks,
</span></p>
<p style="margin:0in;font-size:11pt;font-family:Calibri, sans-serif;" class="yiv3643911366x_MsoNormal">
<span style="font-size:10.5pt;font-family:Roboto;background:white;color:rgb(22, 25, 31);">Sarwar</span></p>
</div>
</div>
</div>

</div></div>
            </div>
        </div></body></html>
------=_Part_6267225_1396007580.1697247420902--