Azure Database for PostgreSQL - Mini Project: Build & Apply

Azure Database for PostgreSQL Setup

📖 Scenario: You are setting up a cloud database for a small business application. The business needs a reliable and managed PostgreSQL database on Azure to store customer data securely.

🎯 Goal: Build an Azure Database for PostgreSQL instance with basic configuration, including resource group, server creation, firewall rule, and database creation.

📋 What You'll Learn

Create a resource group named pg-resource-group

Create an Azure Database for PostgreSQL server named pg-server-demo in the eastus region

Set the administrator login to pgadmin with password StrongP@ssw0rd!

Configure a firewall rule named AllowLocal to allow access from IP 0.0.0.0

Create a database named customerdb on the PostgreSQL server

💡 Why This Matters

🌍 Real World

Managed PostgreSQL databases on Azure are used by businesses to store and manage data securely without managing physical hardware.

💼 Career

Cloud engineers and database administrators often create and configure managed database services like Azure Database for PostgreSQL to support application data needs.

1

Create the resource group

Write an Azure CLI command to create a resource group named pg-resource-group in the eastus region.

Azure

# Your Azure CLI command here to create the resource group

Need a hint?

Use az group create with --name and --location options.

2

Create the PostgreSQL server

Write an Azure CLI command to create an Azure Database for PostgreSQL server named pg-server-demo in the resource group pg-resource-group with administrator login pgadmin and password StrongP@ssw0rd! in the eastus region.

Azure

az group create --name pg-resource-group --location eastus
# Your Azure CLI command here to create the PostgreSQL server

Need a hint?

Use az postgres server create with the required parameters including --resource-group, --name, --admin-user, and --admin-password.

3

Add a firewall rule

Write an Azure CLI command to add a firewall rule named AllowLocal to the PostgreSQL server pg-server-demo in resource group pg-resource-group that allows access from IP address 0.0.0.0 to 0.0.0.0.

Azure

az group create --name pg-resource-group --location eastus
az postgres server create --resource-group pg-resource-group --name pg-server-demo --location eastus --admin-user pgadmin --admin-password StrongP@ssw0rd! --sku-name B_Gen5_1 --version 11
# Your Azure CLI command here to add the firewall rule

Need a hint?

Use az postgres server firewall-rule create with --resource-group, --server, --name, --start-ip-address, and --end-ip-address.

4

Create the PostgreSQL database

Write an Azure CLI command to create a database named customerdb on the PostgreSQL server pg-server-demo in resource group pg-resource-group.

Azure

az group create --name pg-resource-group --location eastus
az postgres server create --resource-group pg-resource-group --name pg-server-demo --location eastus --admin-user pgadmin --admin-password StrongP@ssw0rd! --sku-name B_Gen5_1 --version 11
az postgres server firewall-rule create --resource-group pg-resource-group --server pg-server-demo --name AllowLocal --start-ip-address 0.0.0.0 --end-ip-address 0.0.0.0
# Your Azure CLI command here to create the database

Need a hint?

Use az postgres db create with --resource-group, --server-name, and --name to create the database.