Forum Discussion

emartinezh's avatar
emartinezh
Helper I
2 years ago

Postgresql server extraction not working due to firewall.

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 ...
data warehouse
emartinezh's avatar
emartinezh
Helper I
2 years ago

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 :).

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi emartinezh 
Thanks for the details.

    • emartinezh's avatar
      emartinezh
      Helper I
      2 years ago

      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.

       

    • emartinezh's avatar
      emartinezh
      Helper I
      2 years ago

      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.