Guides
How to connect to Azure Database for PostgreSQL
Connect your desktop database client to Azure Database for PostgreSQL. This guide covers firewall configuration, SSL requirements, and connection formatting.
Step by step
1. Get your server name
In Azure Portal, go to your PostgreSQL server. Copy the Server name (e.g., myserver.postgres.database.azure.com).
2. Configure firewall rules
In Connection security, add your client IP address to the firewall rules. Click 'Add current client IP address' for quick setup.
3. Get connection credentials
Use the admin username you set (format: username@servername) and your password. For production, create users with limited permissions.
4. Connect in RowDex
Open RowDex, create a new PostgreSQL connection. Host: myserver.postgres.database.azure.com, Port: 5432, User: username@servername, enable SSL (required).
5. Test and save
Click Test Connection. Azure PostgreSQL requires SSL — RowDex enables it automatically when you check the SSL option.
Tips
- Azure PostgreSQL usernames include the server name: user@servername — don't forget the suffix.
- SSL is enforced by default on Azure PostgreSQL. Always enable SSL in RowDex.
- Use 'Allow access to Azure services' only if connecting from Azure VMs — otherwise restrict to specific IPs.
- For private endpoints, configure Azure Private Link and connect through a VNet.
FAQ
Why does Azure PostgreSQL require user@servername format?
Azure uses this format to route connections to the correct server in their multi-tenant infrastructure. Always include @servername in your username.
Does RowDex support SSL for Azure PostgreSQL?
Yes. Enable SSL in the connection settings. Azure PostgreSQL enforces SSL by default.
Can I connect to Azure PostgreSQL from RowDex?
Yes. RowDex fully supports Azure Database for PostgreSQL with SSL and firewall configuration.
Try RowDex free
Native database client for macOS, Windows, and Linux. Basic is free — download and connect in minutes.