Skip to main content

Set up a PostgreSQL database on Azure

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

Prerequisites​

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 new db
  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.

compute storage

  1. After saving, return to the creation screen

  2. Update authentication settings:

    • Set an admin login and password
    • Record your password for later use in your Instance vault auth
  3. Click Next to configure networking

  4. 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 networking
  5. Click Next to Security and leave default settings

  6. Click Next to Tags and add any required tags

  7. Review settings and click Create

note

For more details, reference the Azure documentation.

  1. 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.