topic Re: Postgresql server extraction not working due to firewall. in Data Warehouse

Postgresql server extraction not working due to firewall.

emartinezh — Wed, 17 Apr 2024 08:53:44 GMT

Hello good morning and thanks for your effort helping people :).

As i said in my first and last post, in my company we're migrating all our infraestructure deployed in Azure to Azure Fabric.

Right now we've got configured a firewall in our DWH sql servers where the datafactory write/read all the tables, to save this firewall limitation, we got introduced the Datafactory ip ranges for the region the datafactory are deployed and it's working as usual.

With this last escenario, we wanted to connect to an origin PostgreSQL from dataflow but this postgresql has a firewall too deployed on the client side, we asked for add this range of ips (13.69.233.136/29, 13.74.105.192/29, 52.138.229.72/29, 52.146.133.128/27) that we obtained from https://learn.microsoft.com/en-us/azure/synapse-analytics/security/gateway-ip-addresses (North Europe Region) but the connection is not working.

Do you have any information about the limitation of connection postgresql server that i could not find?

Or do i have to add another range of ips that Fabric uses?

Thank you very much in advance,

Best Regards.

Eduardo.

Re: Postgresql server extraction not working due to firewall.

Anonymous — Wed, 17 Apr 2024 16:08:50 GMT

Hi emartinezh
Thanks for using Fabric Community and for your kind words 🙂 🙂
As you mentioned above, The DWH SQL server here is PostgreSQL? In Azure? On VMs or PaaS? Can you please provide me these details.

Re: Postgresql server extraction not working due to firewall.

emartinezh — Thu, 18 Apr 2024 06:55:52 GMT

Hello Nikhilan and thank you for your reply :).

Right now in our "old environment" (datafactory) we're using the PostgreSQL (Legacy) connector with the same credentials and it's working well.

Do you think that we will have to add another range of ips to this postgresql firewall?

I will ask the client the version of this postgresql so i can give you more information.

Thank you in advance.

Best Regards.

Eduardo.

Re: Postgresql server extraction not working due to firewall.

emartinezh — Mon, 22 Apr 2024 11:33:30 GMT

Hello.

I'm still waiting for the client to tell me the postgresql version they're using right now.

I will update this post once i got the answer.

Thank you so much :).

Re: Postgresql server extraction not working due to firewall.

Anonymous — Mon, 22 Apr 2024 17:39:17 GMT

Hi emartinezh
Thanks for the details.

Re: Postgresql server extraction not working due to firewall.

Anonymous — Mon, 22 Apr 2024 18:37:47 GMT

Hi emartinezh
You can refer to Azure IP ranges Service Tags :
Download Azure IP Ranges and Service Tags – Public Cloud from Official Microsoft Download Center

You can also refer to this link for more help:
Service tags - Microsoft Fabric | Microsoft Learn

Hope this helps. Please let me know if you need further help.

Re: Postgresql server extraction not working due to firewall.

emartinezh — Tue, 23 Apr 2024 10:21:10 GMT

Hello Anonymous and thank you for your reply.

I have searched in the Azure IP Ranges And Service Tags - Public Cloud.json downloaded from the link u sent me and i found some ranges of ips attaching to the fabric service in the north europe region.

We will ask the client for open this range of ips and delete the other range that i told them to add before.

I will tell you how it evolves.

Thank you so much.

Best Regards.

Re: Postgresql server extraction not working due to firewall.

emartinezh — Tue, 23 Apr 2024 10:30:18 GMT

The ranges that I asked for add of North Europe region are the following.

"13.69.227.232/29",
"13.74.80.74/32",
"13.74.111.144/30",
"40.113.23.157/32",
"40.113.88.37/32",
"40.115.113.228/32",
"52.138.143.55/32",
"52.138.229.68/30",
"137.116.252.9/32",
"2603:1020:5:402::98/125",
"2603:1020:5:802::98/125",
"2603:1020:5:c02::98/125"

Added this to the post for if in the future the problem is solved the next person has a good solution.

Thank you so much 🙂

Re: Postgresql server extraction not working due to firewall.

Anonymous — Tue, 23 Apr 2024 17:05:22 GMT

Hi emartinezh
Thanks for providing the detailed information. Our internal team has suggested that the best course of action is to open a support ticket and have our support team take a closer look at it.

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

Re: Postgresql server extraction not working due to firewall.

emartinezh — Wed, 24 Apr 2024 07:44:28 GMT

Hello Anonymous

We have added all the service tags ip of Microsoft Fabric Service North Europe to the postgresql service and we still cant connect to this server.

The error we're experiencing now is the following:

Failed to connect to xx.xxx.xxx.xxx:5432 Check network connectivity setting of your Azure Postgre SQL flexible server, if Private Access(VNet integration) is selected, please use SHIR to connect. Failed to connect to xx.xxx.xxx.xxx:xxx Timeout during connection attempt.

And in datafactory we've deployed the same connection and it's working well.

Thank you in advance.

BEst regards.

Re: Postgresql server extraction not working due to firewall.

emartinezh — Wed, 24 Apr 2024 08:25:59 GMT

We've opened a support ticket and the number is: "2404240050000739"

Thank you so much.

Best regards.

Eduardo