Set up a PostgreSQL database on Azure

This guide explains how to configure a PostgreSQL database on Azure for use with an Ascend Instance. See this Azure guide for additional details.

Prerequisites

• Azure account with permission to create Azure resources

Create a PostgreSQL instance on Azure

1. Navigate to the Azure portal

2. Search for and select Azure Database for PostgreSQL flexible servers

3. Click Create to create a new instance

4. Configure basic settings:

   • Select your Subscription
   • Choose a Resource Group
   • Enter a Server Name (must be globally unique)
   • Select your Region

5. Click Configure Server to adjust compute size

note

This server receives minimal queries, so start with the smallest compute size, 32 GiB.

note

With self-hosted instances, you are responsible for the underlying infrastructure. Ensure you understand how to recover your database in case of data loss.

6. After saving, return to the creation screen

7. Update authentication settings:

   • Set an admin login and password
   • Record your password for later use in your Instance vault

8. Click Next to configure networking

9. Set networking configuration to allow your self-hosted Instance to access this database:

   • Option 1: Enable public access and add firewall rules for your AKS egress IPs
   • Option 2: Set up private access via VNet Integration

10. Click Next to Security and leave default settings

11. Click Next to Tags and add any required tags

12. Review settings and click Create

note

For more details, reference the Azure documentation.

13. Note your Endpoint after creation: [server_name].postgres.database.azure.com

🎉 Congratulations! You've successfully set up a PostgreSQL Instance on Azure!

Next steps

Set up your Instance Store to connect your Ascend Instance to PostgreSQL.