From: | M Sarwar <sarwarmd02(at)outlook(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Connecting 2 databases within the same instance |
Date: | 2023-10-14 22:14:30 |
Message-ID: | DM4PR19MB5978237837DEC65688502BD1D3D1A@DM4PR19MB5978.namprd19.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello Ron,
Thank you so much! I will go over them.
Sarwar
________________________________
From: Ron <ronljohnsonjr(at)gmail(dot)com>
Sent: Friday, October 13, 2023 10:15 PM
To: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
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<https://www.postgresql.org/docs/current/dblink.html> 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(at)yahoo(dot)com><mailto:gurung_swastik(at)yahoo(dot)com>
Date: 10/13/23 9:37 PM (GMT-05:00)
To: pgsql-admin(at)postgresql(dot)org<mailto:pgsql-admin(at)postgresql(dot)org>, M Sarwar <sarwarmd02(at)outlook(dot)com><mailto:sarwarmd02(at)outlook(dot)com>
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(at)outlook(dot)com><mailto: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
--
Born in Arizona, moved to Babylonia.
From | Date | Subject | |
---|---|---|---|
Next Message | M Sarwar | 2023-10-14 22:16:03 | Re: Connecting 2 databases within the same instance |
Previous Message | Ron | 2023-10-14 21:06:05 | Re: Big table and partition |