Re: Connecting 2 databases within the same instance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hello Ron,
Thank you so much! I will go over them.
Sarwar


From: Ron <ronljohnsonjr@xxxxxxxxx>
Sent: Friday, October 13, 2023 10:15 PM
To: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Connecting 2 databases within the same instance
 
Google is your friend.  Searching for "postgresql dblink" and "postgresql fdw" take you right to the documentation:
https://www.postgresql.org/docs/15/dblink.html
https://www.postgresql.org/docs/current/postgres-fdw.html

DB Link is much older, while FDW has better syntax and is usually faster:
"
The functionality provided by this module overlaps substantially with the functionality of the older dblink module. But postgres_fdw provides more transparent and standards-compliant syntax for accessing remote tables, and can give better performance in many cases.
"

On 10/13/23 20:40, M Sarwar wrote:
Hi,
Are you saying that Db Link is existing in the Postgress or just referring to FDW ?
Sarwar




Sent from my Galaxy



-------- Original message --------
From: swastik Gurung <gurung_swastik@xxxxxxxxx>
Date: 10/13/23 9:37 PM (GMT-05:00)
Subject: Re: Connecting 2 databases within the same instance

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@xxxxxxxxxxx> 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


--
Born in Arizona, moved to Babylonia.

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux