Azure Flexible Server

Prerequisites

• -Azure Database for PostgreSQL - Flexible Server
• -Public access enabled or VNet integration with dbaBrain
• -Admin credentials to create a monitoring user

Create a monitoring user

sql
CREATE USER dbabrain_monitor WITH PASSWORD 'your-secure-password';
GRANT pg_monitor TO dbabrain_monitor;
GRANT USAGE ON SCHEMA public TO dbabrain_monitor;

Firewall Rules

In the Azure portal, go to your Flexible Server > Networking and add a firewall rule allowing dbaBrain IP ranges. For public access, add the IPs under "Firewall rules."

Connect in dbaBrain

text
Host: your-server.postgres.database.azure.com
Port: 5432
Database: your_database
Username: dbabrain_monitor
Password: your-secure-password
SSL Mode: require

Azure Monitor Integration (Optional)

For Azure-specific metrics, provide a service principal with Monitoring Reader role on your PostgreSQL resource. Configure in dbaBrain Settings > Integrations.