Azure Database for PostgreSQL Quickstart

Prerequisites

• Azure subscription (free trial works)
• Azure CLI installed (az)
• psql client installed locally

Step 1 – Create a PostgreSQL server

az group create --name myResourceGroup --location eastus
az postgres server create \
  --resource-group myResourceGroup \
  --name mypgserver \
  --location eastus \
  --admin-user adminuser \
  --admin-password MyP@ssw0rd! \
  --sku-name B_Gen5_2 \
  --version 14

Step 2 – Configure firewall rule

az postgres server firewall-rule create \
  --resource-group myResourceGroup \
  --server-name mypgserver \
  --name AllowMyIP \
  --start-ip-address $(curl -s ifconfig.me) \
  --end-ip-address $(curl -s ifconfig.me)

Step 3 – Create a database

az postgres db create \
  --resource-group myResourceGroup \
  --server-name mypgserver \
  --name mysampledb

Step 4 – Connect with psql

psql "host=mypgserver.postgres.database.azure.com port=5432 dbname=mysampledb user=adminuser@mypgserver password=MyP@ssw0rd!"

Next steps

• Configure SSL connection (recommended)
• Scale compute or storage
• Enable automatic backups & point‑in‑time restore
• Integrate with Azure Monitor for metrics and alerts