Connect Postgres database to Public IP

Question

I have created a Postgres database and a Public IP while I am migrating from on premises to Cloud. Need help on following things.

1. How to I connect the Static IP to the database. The static IP is going to be defined on the gateway device via which all traffic from applications would be diverted to this database.
2. How do I provide authentication to users.
3. How do I configure security e.g. DDOS or firewall protection?.

Answer 1

Hi @Anonymous , welcome to Microsoft Q&A forum.

1). We can go to connection security and add the IPs in the firewall rules as mentioned in below screenshot:

2). Users can be created and then we can use the same credentials to authenticate them:

Create users in Azure Database for PostgreSQL - Single Server

3). For security, please refer to below article:

Azure security baseline for Azure Database for PostgreSQL - Single Server

Quickstart: Create and configure Azure DDoS Protection Standard

Please let us know if this helps or else we can discuss further. If answer helps, you can mark it 'Accept Answer'.