This directory contains Terraform modules and a deployment script for provisioning Azure Database for PostgreSQL Flexible Server resources in LocalStack for Azure. Refer to the Azure Database for PostgreSQL Flexible Server guide for details about the sample application.
Before deploying this solution, ensure you have the following tools installed:
- LocalStack for Azure: Local Azure cloud emulator for development and testing
- Visual Studio Code: Code editor installed on one of the supported platforms
- Terraform: Infrastructure as Code tool for provisioning Azure resources
- Python 3.12+: Required for running the Flask web application
- Docker: Container runtime required for LocalStack
- Azure CLI: Azure command-line interface
- azlocal CLI: LocalStack Azure CLI wrapper
- jq: JSON processor for scripting and parsing command outputs
The deploy.sh Bash script uses the azlocal CLI instead of the standard Azure CLI to work with LocalStack. Install it using:
pip install azlocalFor more information, see Get started with the az tool on LocalStack.
The main.tf Terraform module creates the following Azure resources:
- Azure Resource Group: Logical container for all resources.
- Azure Database for PostgreSQL Flexible Server: Managed PostgreSQL database server with version 16.
- PostgreSQL Databases: Two databases (
sampledbandanalyticsdb). - Firewall Rules: Three firewall rules (
allow-all,corporate-network,vpn-access).
When using LocalStack for Azure, configure the metadata_host and subscription_id settings in the Azure Provider for Terraform to ensure proper connectivity:
provider "azurerm" {
features {
resource_group {
prevent_deletion_if_contains_resources = false
}
}
# Set the hostname of the Azure Metadata Service (for example management.azure.com)
# used to obtain the Cloud Environment when using LocalStack's Azure emulator.
# This allows the provider to correctly identify the environment and avoid making calls to the real Azure endpoints.
metadata_host="localhost.localstack.cloud:4566"
# Set the subscription ID to a dummy value when using LocalStack's Azure emulator.
subscription_id = "00000000-0000-0000-0000-000000000000"
}You can set up the Azure emulator by utilizing LocalStack for Azure Docker image. Before starting, ensure you have a valid LOCALSTACK_AUTH_TOKEN to access the Azure emulator. Refer to the Auth Token guide to obtain your Auth Token and specify it in the LOCALSTACK_AUTH_TOKEN environment variable. The Azure Docker image is available on the LocalStack Docker Hub. To pull the Azure Docker image, execute the following command:
docker pull localstack/localstack-azure-alphaStart the LocalStack Azure emulator using the localstack CLI, execute the following command:
export LOCALSTACK_AUTH_TOKEN=<your_auth_token>
IMAGE_NAME=localstack/localstack-azure-alpha localstack startNavigate to the terraform folder:
cd samples/postgresql-flexible-server/python/terraformMake the script executable:
chmod +x deploy.shRun the deployment script:
./deploy.shAfter deployment, you can use the validate.sh script to verify that all resources were created and configured correctly:
#!/bin/bash
# Variables
ENVIRONMENT=$(az account show --query environmentName --output tsv)
# Choose the appropriate CLI based on the environment
if [[ $ENVIRONMENT == "LocalStack" ]]; then
echo "Using azlocal for LocalStack emulator environment."
AZ="azlocal"
else
echo "Using standard az for AzureCloud environment."
AZ="az"
fi
# Get resource group name from Terraform output
RESOURCE_GROUP=$(terraform output -raw resource_group_name)
# Check resource group
$AZ group show \
--name "$RESOURCE_GROUP" \
--output table
# List resources
$AZ resource list \
--resource-group "$RESOURCE_GROUP" \
--output table
# Check PostgreSQL Flexible Server
SERVER_NAME=$(terraform output -raw server_name)
$AZ postgres flexible-server show \
--name "$SERVER_NAME" \
--resource-group "$RESOURCE_GROUP" \
--output tableTo destroy all created resources:
# Destroy Terraform-managed resources
terraform destroy -auto-approve
# Verify deletion
azlocal group list --output tableThis will remove all Azure resources created by the Terraform deployment script.