Share via

Connecting Azure PostgreSQL from Public SaaS Service

GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
2024-07-25T22:13:21.1833333+00:00

How can I connect my Azure PostgreSQL database from a public SaaS service while ensuring secure access?

Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 29,017 Reputation points Microsoft Employee
    2024-07-25T22:16:50.3233333+00:00

    Greetings!

    To connect your Azure PostgreSQL database from a public SaaS service, you need to consider both security and accessibility. The recommended approach is to use a private endpoint for internal access and a public IP for external access. This configuration ensures that internal traffic remains within the Azure network, enhancing security, while the public IP allows external services to connect to your database.

    To set this up, you can follow these steps:

    1. Create a Private Endpoint: This allows you to securely connect to your database from within your Azure virtual network. You can find detailed steps in the Azure Private Endpoint documentation.
    2. Configure Public IP Access: Ensure that your PostgreSQL server's firewall rules are set to allow connections from the public IP addresses of your SaaS service. Detailed steps can be found in the Azure Firewall configuration documentation.

    Regards

    Geetha

    0 comments