question

VitaliiManoilo-5637 avatar image
0 Votes"
VitaliiManoilo-5637 asked VitaliiManoilo-5637 commented

How to connect two Azure postgreSQL Databases on different hosts with a postgre_fdw

Hello, I'm trying to connect my Azure DB to another Azure DB on a different host using postgres_fdw.

I receive an error:

ERROR: could not connect to server ""
DETAIL: could not connect to server: Network is down (0x00002742/10050)
Is the server running on host ".postgres.database.azure.com" (IP address *) and accepting
TCP/IP connections on port 5432?
SQL state: 08001

I believe the firewall on the 2nd Azure DB doesn't let my 1st DB connect.
However, I'm able to connect to the 2nd Azure DB using my localhost (my public IP is in the whitelist).

Question:

How to whitelist my 1st Azure DB so the firewall on 2nd DB lets me connect? Or is there anything else I need to configure to allow this?

Thanks.

azure-database-postgresql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@NavtejSaini-MSFT Thank you for your reply.

The approach described on blog, would raise some security concerns.
The organization would not be able to allow access regardless of the azure service. The feature will allow/accept connections without knowing which service is using.


I’m wondering if there is a way to whitelist only one receiving server (1st host) on the sending server (2nd host).

0 Votes 0 ·

1 Answer

NavtejSaini-MSFT avatar image
1 Vote"
NavtejSaini-MSFT answered

@VitaliiManoilo-5637

This is definitely a firewall issue. Please find this document for more information regarding this.

Regards
Navtej S


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@VitaliiManoilo-5637 Please convey if you were able to check this information.

0 Votes 0 ·