Create virtual endpoints for read replicas with Terraform

Using Terraform, you can create and manage virtual endpoints for read replicas in Azure Database for PostgreSQL-Flexible Server. Terraform is an open-source infrastructure-as-code tool that allows you to define and provision infrastructure using a high-level configuration language.

Prerequisites

Before you begin, ensure you have the following:

Ensure you have a basic understanding of Terraform syntax and Azure resource provisioning.

Step-by-Step Terraform Configuration: Provide a step-by-step guide on configuring virtual endpoints for read replicas using Terraform.

Configuring virtual endpoints

Follow these steps to create virtual endpoints for read replicas in Azure Database for PostgreSQL - Flexible Server:

Initialize the Terraform configuration

Create a main.tf file and define the Azure provider.

 provider "azurerm" {
   features {}

   environment = "china"
 }

 resource "azurerm_resource_group" "example" {
   name     = "example-resources"
   location = "China North 3"
 }

Create the primary Azure Database for PostgreSQL

Define the primary PostgreSQL server resource.

resource "azurerm_postgresql_flexible_server" "primary" {
  name                = "primary-server"
  resource_group_name = azurerm_resource_group.example.name
  location            = azurerm_resource_group.example.location
  version             = "12"
  administrator_login = "adminuser"
  administrator_password = "password"
  sku_name            = "Standard_D4s_v3"

  storage_mb = 32768
  backup_retention_days = 7
  geo_redundant_backup = "Disabled"
  high_availability {
    mode = "ZoneRedundant"
  }
}

Create read replicas

Define the read replicas for the primary server.

resource "azurerm_postgresql_flexible_server_replica" "replica" {
  name                = "replica-server"
  resource_group_name = azurerm_resource_group.example.name
  location            = azurerm_resource_group.example.location
  source_server_id    = azurerm_postgresql_flexible_server.primary.id
}

Configure virtual endpoints

Define the necessary resources to configure virtual endpoints.

resource "azurerm_private_endpoint" "example" {
  name                = "example-private-endpoint"
  location            = azurerm_resource_group.example.location
  resource_group_name = azurerm_resource_group.example.name
  subnet_id           = azurerm_subnet.example.id

  private_service_connection {
    name                           = "example-privateserviceconnection"
    private_connection_resource_id = azurerm_postgresql_flexible_server.primary.id
    is_manual_connection           = false
    subresource_names              = ["postgresqlServer"]
  }
}

Apply the configuration

Initialize Terraform and apply the configuration.

terraform init terraform apply

Confirm the apply action when prompted. Terraform provisions the resources and configure the virtual endpoints as specified.

For additional info about Virtual endpoints, refer to create virtual endpoints