你当前正在访问 Microsoft Azure Global Edition 技术文档网站。如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

New-AzPostgreSqlFlexibleServer

参考

模块:: Az.PostgreSql

创建新服务器。

语法

New-AzPostgreSqlFlexibleServer
   [-Name <String>]
   [-ResourceGroupName <String>]
   [-SubscriptionId <String>]
   [-AdministratorLoginPassword <SecureString>]
   [-AdministratorUserName <String>]
   [-BackupRetentionDay <Int32>]
   [-HaEnabled <String>]
   [-Location <String>]
   [-PrivateDnsZone <String>]
   [-PublicAccess <String>]
   [-Sku <String>]
   [-SkuTier <String>]
   [-StorageInMb <Int32>]
   [-Subnet <String>]
   [-SubnetPrefix <String>]
   [-Tag <Hashtable>]
   [-Version <ServerVersion>]
   [-Vnet <String>]
   [-VnetPrefix <String>]
   [-Zone <String>]
   [-DefaultProfile <PSObject>]
   [-AsJob]
   [-NoWait]
   [-Confirm]
   [-WhatIf]
   [<CommonParameters>]

说明

创建新服务器。

示例

示例 1：使用参数创建新的 PostgreSql 灵活服务器

New-AzPostgreSqlFlexibleServer -Name postgresql-test -ResourceGroupName PowershellPostgreSqlTest `
-Location eastus -AdministratorUserName postgresqltest -AdministratorLoginPassword $password -Sku Standard_D2s_v3 -SkuTier GeneralPurpose -Version 12 -StorageInMb 131072 -PublicAccess none

Checking the existence of the resource group PowershellPostgreSqlTest ...
Resource group PowershellPostgreSqlTest exists ? : True
Creating PostgreSQL server postgresql-test in group PostgreSqlTest...
Your server postgresql-test is using sku Standard_D2s_v3 (Paid Tier).
Please refer to https://aka.ms/postgresql-pricing for pricing details

Name                Location  SkuName         SkuTier        AdministratorLogin StorageSizeGb
----                --------  -------         -------        ------------------ -------------
postgresql-test     East US   Standard_D2s_v3 GeneralPurpose daeunyim           128

示例 2：使用默认设置创建新的 PostgreSql 灵活服务器

$server = New-AzPostgreSqlFlexibleServer

Creating resource group group00000000...
Creating PostgreSQL server server00000000 in group group00000000...
Your server postgresql-test is using sku Standard_D2s_v3 (Paid Tier).
Please refer to https://aka.ms/postgresql-pricing for pricing details

Name                Location  SkuName         SkuTier        AdministratorLogin StorageSizeGb
----                --------  -------         -------        ------------------ -------------
postgresql-test     East US   Standard_D2s_v3 GeneralPurpose daeunyim           128

此 cmdlet 创建具有默认参数值的 PostgreSql 灵活服务器，并在启用公共访问的情况下预配服务器。位置的默认值为美国东部 2，Sku 为Standard_D2s_v3，Sku 层为 GeneralPurpose，存储大小为 128GiB。

如果要查找服务器的自动生成的密码，请使用 ConvertFrom-SecureString 将“SecurePassword”属性转换为纯文本。（例如，$server。SecuredPassword |ConvertFrom-SecureString -AsPlainText）

示例 3：使用现有子网创建新的 PostgreSql 灵活服务器

$Subnet = '/subscriptions/00000000-0000-0000-0000-0000000000/resourceGroups/PowershellPostgreSqlTest/providers/Microsoft.Network/virtualNetworks/vnetname/subnets/subnetname'
$DnsZone = '/subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/postgresqltest/providers/Microsoft.Network/privateDnsZones/testserver.private.postgres.database.azure.com'
New-AzPostgreSqlFlexibleServer  -ResourceGroupName postgresqltest -ServerName testserver -Subnet $Subnet -PrivateDnsZone $DnsZone

Resource group PowershellPostgreSqlTest exists ? : True
You have supplied a subnet Id.
Verifying its existence...
Creating PostgreSQL server testserver in group PowershellPostgreSqlTest...
Your server server00000000 is using sku Standard_D2s_v3 (Paid Tier).
Please refer to https://aka.ms/postgresql-pricing for pricing details
Creating database flexibleserverdb...

Name                Location  SkuName         SkuTier        AdministratorLogin StorageSizeGb
----                --------  -------         -------        ------------------ -------------
postgresql-test     East US   Standard_D2s_v3 GeneralPurpose daeunyim           128

此 cmdlet 使用用户提供的现有子网 ID 创建 PostgreSql 灵活服务器。如果尚未委托子网，则子网将委托给 PostgreSQL 灵活服务器。不能使用委托给不同服务的子网。子网可以位于不同的资源组中。

示例 4：使用虚拟网络和子网名称创建新的 PostgreSql 灵活服务器

New-AzPostgreSqlFlexibleServer -Name postgresql-test -ResourceGroupName PowershellPostgreSqlTest -Vnet postgresql-vnet -Subnet postgresql-subnet -VnetPrefix 10.0.0.0/16 -SubnetPrefix 10.0.0.0/24 -PrivateDnsZone /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/PowershellPostgreSqlTest/providers/Microsoft.Network/privateDnsZones/postgresql-test.private.postgres.database.azure.com

Resource group PowershellPostgreSqlTest exists ? : True
Creating new vnet postgresql-vnet in resource group PowershellPostgreSqlTest
Creating new subnet postgresql-subnet in resource group PowershellPostgreSqlTest and delegating it to Microsoft.DBforPostgreSQL/flexibleServers
Creating PostgreSQL server postgresql-test in group PowershellPostgreSqlTest...
Your server postgresql-test is using sku Standard_D2s_v3 (Paid Tier).
Please refer to https://aka.ms/postgresql-pricing for pricing details
Creating database flexibleserverdb...

Name                Location  SkuName         SkuTier        AdministratorLogin StorageSizeGb
----                --------  -------         -------        ------------------ -------------
postgresql-test     East US   Standard_D2s_v3 GeneralPurpose daeunyim           128

此 cmdlet 创建具有 vnet 名称、子网名称、vnet 前缀和子网前缀的 PostgreSql 灵活服务器。如果虚拟网络和子网不存在，则 cmdlet 将创建一个。

示例 5：使用虚拟网络创建新的 PostgreSql 灵活服务器

$Vnet = 'vnetname'
New-AzPostgreSqlFlexibleServer -ResourceGroupName PowershellPostgreSqlTest -Vnet $Vnet -PrivateDnsZone /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/PowershellPostgreSqlTest/providers/Microsoft.Network/privateDnsZones/testserver.private.postgres.database.azure.com

# or

$Vnet = '/subscriptions/00000000-0000-0000-0000-0000000000/resourceGroups/PowershellPostgreSqlTest/providers/Microsoft.Network/virtualNetworks/vnetname'
New-AzPostgreSqlFlexibleServer  -ResourceGroupName PowershellPostgreSqlTest -Vnet $Vnet -PrivateDnsZone /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/PowershellPostgreSqlTest/providers/Microsoft.Network/privateDnsZones/testserver.private.postgres.database.azure.com

Resource group PowershellPostgreSqlTest exists ? : True
You have supplied a vnet Id/name.
Verifying its existence...
Creating new vnet vnetname in resource group PowershellPostgreSqlTest
Creating new subnet Subnetserver00000000 in resource group PowershellPostgreSqlTest and delegating it to Microsoft.DBforPostgreSQL/flexibleServers
Creating PostgreSQL server server00000000 in group PowershellPostgreSqlTest...
Your server server00000000 is using sku Standard_D2s_v3 (Paid Tier).
Please refer to https://aka.ms/postgresql-pricing for pricing details
Creating database flexibleserverdb...

Name                Location  SkuName         SkuTier        AdministratorLogin StorageSizeGb
----                --------  -------         -------        ------------------ -------------
postgresql-test     East US   Standard_D2s_v3 GeneralPurpose daeunyim           128

此 cmdlet 使用用户提供的 vnet ID 或 vnet 名称创建 PostgreSql 灵活服务器。如果虚拟网络不存在，cmdlet 将创建一个。

示例 6：创建新的具有对所有 IP 的公共访问权限的 PostgreSql 灵活服务器

New-AzPostgreSqlFlexibleServer -Name postgresql-test -ResourceGroupName PowershellPostgreSqlTest -PublicAccess All

Resource group PowershellPostgreSqlTest exists ? : True
Creating PostgreSQL server postgresql-test in group PowershellPostgreSqlTest...
Your server postgresql-test is using sku Standard_D2s_v3 (Paid Tier).
Please refer to https://aka.ms/postgresql-pricing for pricing details
Creating database flexibleserverdb...
Configuring server firewall rule to accept connections from 0.0.0.0 to 255.255.255.255

Name                Location  SkuName         SkuTier        AdministratorLogin StorageSizeGb
----                --------  -------         -------        ------------------ -------------
postgresql-test     East US   Standard_D2s_v3 GeneralPurpose daeunyim           128

此 cmdlet 创建开放到所有 IP 地址的 PostgreSql 灵活服务器。

示例 7：使用防火墙创建新的 PostgreSql 灵活服务器

New-AzPostgreSqlFlexibleServer -Name postgresql-test -ResourceGroupName PowershellPostgreSqlTest -PublicAccess 10.10.10.10-10.10.10.12

Resource group PowershellPostgreSqlTest exists ? : True
Creating PostgreSQL server postgresql-test in group PowershellPostgreSqlTest...
Your server postgresql-test is using sku Standard_D2s_v3 (Paid Tier).
Please refer to https://aka.ms/postgresql-pricing for pricing details
Creating database flexibleserverdb...
Configuring server firewall rule to accept connections from 10.10.10.10 to 10.10.10.12

Name                Location  SkuName         SkuTier        AdministratorLogin StorageSizeGb
----                --------  -------         -------        ------------------ -------------
postgresql-test     East US   Standard_D2s_v3 GeneralPurpose daeunyim           128

此 cmdlet 创建打开到指定 IP 地址的 PostgreSql 灵活服务器。

参数

-AdministratorLoginPassword

管理员的密码。最少 8 个字符，最多 128 个字符。密码必须包含以下类别中的三个类别的字符：英文大写字母、英文小写字母、数字和非字母数字字符。

Type:	SecureString
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AdministratorUserName

服务器管理员istrator 用户名。设置后，无法更改它。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-AsJob

以作业身份运行命令。

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-BackupRetentionDay

服务器的备份保留日。日计数介于 7 到 35 之间。

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Confirm

提示你在运行 cmdlet 之前进行确认。

Type:	SwitchParameter
Aliases:	cf
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-DefaultProfile

用于与 Azure 通信的凭据、帐户、租户和订阅。

Type:	PSObject
Aliases:	AzureRMContext, AzureCredential
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-HaEnabled

启用或禁用高可用性功能。允许的值：已启用、禁用

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Location

资源所在的位置。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Name

服务器的名称。

Type:	String
Aliases:	ServerName
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-NoWait

异步运行命令。

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-PrivateDnsZone

现有专用 DNS 区域的 ID。可以使用同一资源组、不同资源组或不同订阅中的专用 DNS 区域。 dns 区域的后缀必须与服务器的完全限定域的后缀相同。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-PublicAccess

确定公共访问。输入要包含在 IP 允许列表中的单个或一系列 IP 地址。 IP 地址范围必须是短划线分隔的，并且不包含任何空格。如果指定 0.0.0.0，则允许从 Azure 中部署的任何资源进行公共访问来访问服务器。指定任何 IP 地址不会在公共访问模式下设置服务器，但不创建防火墙规则。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-ResourceGroupName

包含资源的资源组的名称，可以从 Azure 资源管理器 API 或门户获取此值。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Sku

sku 的名称，通常为层 + 系列 + 核心，例如Standard_B1ms，Standard_D2s_v3。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SkuTier

服务器的计算层。接受的值：可突发、GeneralPurpose、内存优化。默认值：可突发。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-StorageInMb

服务器允许的最大存储。

Type:	Int32
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Subnet

要创建的现有子网的名称或 ID 或新子网的名称。请注意，子网将委托给 Microsoft.DBforPostgreSQL/flexibleServers。进行委托后，此子网不能用于任何其他类型的 Azure 资源。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SubnetPrefix

创建 CIDR 格式的新 vnet 时要使用的子网 IP 地址前缀。默认值为 10.0.0.0/24。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-SubscriptionId

用于标识 Azure 订阅的订阅 ID。

Type:	String
Position:	Named
Default value:	(Get-AzContext).Subscription.Id
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Tag

键值对形式的应用程序特定元数据。

Type:	Hashtable
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Version

服务器版本。

Type:	ServerVersion
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Vnet

要创建的现有虚拟网络的名称或 ID 或新虚拟网络的名称。名称必须包含 2 到 64 个字符。名称必须以字母或数字开头，以字母、数字或下划线结尾，并且只能包含字母、数字、下划线、句点或连字符。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-VnetPrefix

以 CIDR 格式创建新 vnet 时要使用的 IP 地址前缀。默认值为 10.0.0.0/16。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-WhatIf

显示运行该 cmdlet 时会发生什么情况。 cmdlet 未运行。

Type:	SwitchParameter
Aliases:	wi
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

-Zone

要在其中预配资源的可用性区域。

Type:	String
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	False

输出

IServerAutoGenerated

备注

别名