Can't Find Firewall Settings for PostgreSQL Flexible Server

coding_took 20 Reputation points
2024-02-05T17:57:19.76+00:00

I created a Web App + Database and am having problems connecting to the PostgreSQL server using PgAdmin and Azure CLI. All the instructions I'm finding to add my IP address seem to indicate a Firewall setting that I am having a hard time finding. Is there a special way to do so for a PostgreSQL Flexible Server that I'm not seeing? Azure Portal

Azure Database for PostgreSQL
Accepted answer
  1. TP 75,736 Reputation points
    2024-02-05T18:39:53.3466667+00:00

    Hi,

    When you create Web app + database via the portal it configures the database so that only incoming connections from the virtual network are permitted. This can't be changed after creation.

    To connect to your Azure Database for PostgreSQL flexible server you need to connect from an IP on the virtual network. For example, if you had a VM on the same VNet you could SSH/RDP to it and then you would be able to connect to your database from within that VM.

    Please click Accept Answer and upvote if the above was helpful.

    Thanks.

    -TP

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oury Ba-MSFT 16,156 Reputation points Microsoft Employee
    2024-02-05T23:01:01.6433333+00:00

    @coding_took
    Thank you for reaching out. In addition to @TP' s answer. My understanding is that you are looking to connect your web app to your Azure PostgreSQL flexible server with VNET integration. Please let me know if my understanding is not correct. You have to make sure that the web app is in the same virtual network as your PostgreSQL flex. Please see below doc for more details. Connect Azure Database for PostgreSQL - Flexible Server with the private access connectivity method Please do let us know if that does not answer your question by commenting below. Regards, Oury

    0 comments