pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedConnecting 2 databases within the same instance
9+ messages / 4 participants
[nested] [flat]
* Connecting 2 databases within the same instance
@ 2023-10-13 21:53 M Sarwar <sarwarmd02@outlook.com>
0 siblings, 2 replies; 9+ messages in thread
From: M Sarwar @ 2023-10-13 21:53 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting 2 databases within the same instance
@ 2023-10-13 21:58 Scott Ribe <scott_ribe@elevated-dev.com>
parent: M Sarwar <sarwarmd02@outlook.com>
1 sibling, 1 reply; 9+ messages in thread
From: Scott Ribe @ 2023-10-13 21:58 UTC (permalink / raw)
To: M Sarwar <sarwarmd02@outlook.com>; +Cc: pgsql-admin
> 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting 2 databases within the same instance
@ 2023-10-13 22:36 M Sarwar <sarwarmd02@outlook.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 9+ messages in thread
From: M Sarwar @ 2023-10-13 22:36 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: pgsql-admin
Looking into it.
Thanks Scott!
Sarwar
________________________________
From: Scott Ribe <scott_ribe@elevated-dev.com>
Sent: Friday, October 13, 2023 5:58 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Connecting 2 databases within the same instance
> 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://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.postgresql.org%2Fdocs%2Fcurrent...;
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting 2 databases within the same instance
@ 2023-10-14 01:37 swastik Gurung <gurung_swastik@yahoo.com>
parent: M Sarwar <sarwarmd02@outlook.com>
1 sibling, 1 reply; 9+ messages in thread
From: swastik Gurung @ 2023-10-14 01:37 UTC (permalink / raw)
To: pgsql-admin; M Sarwar <sarwarmd02@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
^ permalink raw reply [nested|flat] 9+ messages in thread
* RE: Connecting 2 databases within the same instance
@ 2023-10-14 01:40 M Sarwar <sarwarmd02@outlook.com>
parent: swastik Gurung <gurung_swastik@yahoo.com>
0 siblings, 2 replies; 9+ messages in thread
From: M Sarwar @ 2023-10-14 01:40 UTC (permalink / raw)
To: swastik Gurung <gurung_swastik@yahoo.com>; pgsql-admin
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@yahoo.com>
Date: 10/13/23 9:37 PM (GMT-05:00)
To: pgsql-admin@postgresql.org, M Sarwar <sarwarmd02@outlook.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@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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting 2 databases within the same instance
@ 2023-10-14 02:08 Scott Ribe <scott_ribe@elevated-dev.com>
parent: M Sarwar <sarwarmd02@outlook.com>
1 sibling, 1 reply; 9+ messages in thread
From: Scott Ribe @ 2023-10-14 02:08 UTC (permalink / raw)
To: M Sarwar <sarwarmd02@outlook.com>; +Cc: pgsql-admin
dblink is an older way to access external databases, in general I'd prefer FDW
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/
> On Oct 13, 2023, at 7:40 PM, M Sarwar <sarwarmd02@outlook.com> wrote:
>
> Are you saying that Db Link is existing in the Postgress or just referring to FDW ?
>
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting 2 databases within the same instance
@ 2023-10-14 02:15 Ron <ronljohnsonjr@gmail.com>
parent: M Sarwar <sarwarmd02@outlook.com>
1 sibling, 1 reply; 9+ messages in thread
From: Ron @ 2023-10-14 02:15 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 olderdblink
<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@yahoo.com>
> Date: 10/13/23 9:37 PM (GMT-05:00)
> To: pgsql-admin@postgresql.org, M Sarwar <sarwarmd02@outlook.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@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
>
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting 2 databases within the same instance
@ 2023-10-14 22:14 M Sarwar <sarwarmd02@outlook.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 9+ messages in thread
From: M Sarwar @ 2023-10-14 22:14 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Hello Ron,
Thank you so much! I will go over them.
Sarwar
________________________________
From: Ron <ronljohnsonjr@gmail.com>
Sent: Friday, October 13, 2023 10:15 PM
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.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@yahoo.com><mailto:gurung_swastik@yahoo.com>
Date: 10/13/23 9:37 PM (GMT-05:00)
To: pgsql-admin@postgresql.org<mailto:pgsql-admin@postgresql.org>, M Sarwar <sarwarmd02@outlook.com><mailto:sarwarmd02@outlook.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@outlook.com><mailto: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
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Connecting 2 databases within the same instance
@ 2023-10-14 22:16 M Sarwar <sarwarmd02@outlook.com>
parent: Scott Ribe <scott_ribe@elevated-dev.com>
0 siblings, 0 replies; 9+ messages in thread
From: M Sarwar @ 2023-10-14 22:16 UTC (permalink / raw)
To: Scott Ribe <scott_ribe@elevated-dev.com>; +Cc: pgsql-admin
Hello Scott,
You have a solid point. I am coming onto Postgress environments for the last one year.
Thank you so much,
Sarwar
________________________________
From: Scott Ribe <scott_ribe@elevated-dev.com>
Sent: Friday, October 13, 2023 10:08 PM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Connecting 2 databases within the same instance
dblink is an older way to access external databases, in general I'd prefer FDW
--
Scott Ribe
scott_ribe@elevated-dev.com
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fin%2Fscottribe%2...;
> On Oct 13, 2023, at 7:40 PM, M Sarwar <sarwarmd02@outlook.com> wrote:
>
> Are you saying that Db Link is existing in the Postgress or just referring to FDW ?
>
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2023-10-14 22:16 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-10-13 21:53 Connecting 2 databases within the same instance M Sarwar <sarwarmd02@outlook.com>
2023-10-13 21:58 ` Scott Ribe <scott_ribe@elevated-dev.com>
2023-10-13 22:36 ` M Sarwar <sarwarmd02@outlook.com>
2023-10-14 01:37 ` swastik Gurung <gurung_swastik@yahoo.com>
2023-10-14 01:40 ` M Sarwar <sarwarmd02@outlook.com>
2023-10-14 02:08 ` Scott Ribe <scott_ribe@elevated-dev.com>
2023-10-14 22:16 ` M Sarwar <sarwarmd02@outlook.com>
2023-10-14 02:15 ` Ron <ronljohnsonjr@gmail.com>
2023-10-14 22:14 ` M Sarwar <sarwarmd02@outlook.com>
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