This directory contains the Bicep template 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
- Bicep extension: VS Code extension for Bicep language support and IntelliSense
- Docker: Container runtime required for LocalStack
- Azure CLI: Azure command-line interface
- azlocal CLI: LocalStack Azure CLI wrapper
- Python: Python runtime (version 3.12 or above)
- 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 deploy.sh script creates the Azure Resource Group for all the Azure resources, while the main.bicep Bicep module creates the following Azure resources:
- Azure Database for PostgreSQL Flexible Server: Managed PostgreSQL database server with version 16.
- PostgreSQL Database: The
sampledbdatabase for the Notes application. - Firewall Rule: Allows access from all IP addresses for development.
For more information, see Azure Database for PostgreSQL Flexible Server.
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 bicep folder:
cd samples/postgresql-flexible-server/python/bicepMake 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
# Check resource group
$AZ group show \
--name rg-pgflex-bicep \
--output table
# List resources
$AZ resource list \
--resource-group rg-pgflex-bicep \
--output table
# Check PostgreSQL Flexible Server
$AZ postgres flexible-server list \
--resource-group rg-pgflex-bicep \
--output tableTo destroy all created resources:
# Delete resource group and all contained resources
azlocal group delete --name rg-pgflex-bicep --yes --no-wait
# Verify deletion
azlocal group list --output tableThis will remove all Azure resources created by the Bicep deployment script.