使用 Azure CLI 为 PostgreSQL 服务器创建 Azure 数据库并配置防火墙规则Create an Azure Database for PostgreSQL server and configure a firewall rule using the Azure CLI

此示例 CLI 脚本为 PostgreSQL 服务器创建 Azure 数据库,并配置服务器级防火墙规则。This sample CLI script creates an Azure Database for PostgreSQL server and configures a server-level firewall rule. 成功运行此脚本后,可以通过所有 Azure 服务和配置的 IP 地址访问 PostgreSQL 服务器。Once the script has been successfully run, the PostgreSQL server can be accessed from all Azure services and the configured IP address.

本文需要 Azure CLI 2.0 或更高版本。This article requires Azure CLI version 2.0 or later. 通过运行 az --version 来查看版本。Check the version by running az --version. 请参阅安装 Azure CLI,了解如何安装或升级 Azure CLI 的版本。See Install Azure CLI to install or upgrade your version of Azure CLI.

示例脚本Sample script

在此示例脚本中,编辑突出显示的行,将管理员用户名和密码更新为你自己的。In this sample script, edit the highlighted lines to update the admin username and password to your own.

#!/bin/bash

# Create a resource group
az group create \
--name myresourcegroup \
--location chinaeast2

# Create a PostgreSQL server in the resource group
# Name of a server maps to DNS name and is thus required to be globally unique in Azure.
# Substitute the <server_admin_password> with your own value.
az postgres server create \
--name mydemoserver \
--resource-group myresourcegroup \
--location chinaeast2 \
--admin-user myadmin \
--admin-password <server_admin_password> \
--sku-name GP_Gen5_2 \

# Configure a firewall rule for the server
# The ip address range that you want to allow to access your server
az postgres server firewall-rule create \
--resource-group myresourcegroup \
--server mydemoserver \
--name AllowIps \
--start-ip-address 0.0.0.0 \
--end-ip-address 255.255.255.255

清理部署Clean up deployment

运行脚本示例后,请使用以下命令删除资源组以及与其关联的所有资源。Use the following command to remove the resource group and all resources associated with it after the script has been run.

#!/bin/bash
az group delete --name myresourcegroup

脚本说明Script explanation

此脚本使用下表中列出的命令:This script uses the commands outlined in the following table:

命令Command 说明Notes
az group createaz group create 创建用于存储所有资源的资源组。Creates a resource group in which all resources are stored.
az postgres server createaz postgres server create 创建托管数据库的 PostgreSQL 服务器。Creates a PostgreSQL server that hosts the databases.
az postgres server firewall createaz postgres server firewall create 创建一个防火墙规则,以允许从输入的 IP 地址范围访问服务器及其下的所有数据库。Creates a firewall rule to allow access to the server and databases under it from the entered IP address range.
az group deleteaz group delete 删除资源组,包括所有嵌套的资源。Deletes a resource group including all nested resources.

后续步骤Next steps