Get-AzPostgreSqlFlexibleServer
Gets information about a server.
Syntax
List1 (Default)
Get-AzPostgreSqlFlexibleServer
[-SubscriptionId <String[]>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
Get
Get-AzPostgreSqlFlexibleServer
-Name <String>
-ResourceGroupName <String>
[-SubscriptionId <String[]>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
List
Get-AzPostgreSqlFlexibleServer
-ResourceGroupName <String>
[-SubscriptionId <String[]>]
[-DefaultProfile <PSObject>]
[<CommonParameters>]
GetViaIdentity
Get-AzPostgreSqlFlexibleServer
-InputObject <IPostgreSqlIdentity>
[-DefaultProfile <PSObject>]
[<CommonParameters>]
Description
Gets information about a server.
Examples
Example 1: Get PostgreSql servers in the subscription
Get-AzPostgreSqlFlexibleServer
Name Location SkuName SkuTier AdministratorLogin StorageSizeGb
---- -------- ------- ------- ------------------ -------------
postgresql-test East US Standard_D2s_v3 GeneralPurpose daeunyim 128
postgresql-test-2 East US Standard_D2s_v3 GeneralPurpose daeunyim 128
postgresql-test-3 East US Standard_D2s_v3 GeneralPurpose daeunyim 128
This cmdlet gets PostgreSql servers with default context.
Example 2: Get PostgreSql server by resource group and server name
Get-AzPostgreSqlFlexibleServer -ResourceGroupName PowershellPostgreSqlTest -Name postgresql-test
Name Location SkuName SkuTier AdministratorLogin StorageSizeGb
---- -------- ------- ------- ------------------ -------------
postgresql-test East US Standard_D2s_v3 GeneralPurpose daeunyim 128
This cmdlet gets PostgreSql servers by resource group and server name.
Example 3: Lists all the PostgreSql servers in specified resource group
Get-AzPostgreSqlFlexibleServer -ResourceGroupName PowershellPostgreSqlTest
Name Location SkuName SkuTier AdministratorLogin StorageSizeGb
---- -------- ------- ------- ------------------ -------------
postgresql-test East US Standard_D2s_v3 GeneralPurpose daeunyim 128
postgresql-test-2 East US Standard_D2s_v3 GeneralPurpose daeunyim 128
This cmdlet lists all the PostgreSql servers in the specified resource group.
Example 4: Get PostgreSql server by identity
$ID = "/subscriptions/<SubscriptionId>/resourceGroups/PowershellPostgreSqlTest/providers/Microsoft.DBforPostgreSQL/flexibleServers/postgresql-test"
Get-AzPostgreSqlFlexibleServer -InputObject $ID
Name Location SkuName SkuTier AdministratorLogin StorageSizeGb
---- -------- ------- ------- ------------------ -------------
postgresql-test East US Standard_D2s_v3 GeneralPurpose daeunyim 128
This cmdlet lists gets PostgreSql servers by identity.
Parameters
-DefaultProfile
The DefaultProfile parameter is not functional. Use the SubscriptionId parameter when available if executing the cmdlet against a different subscription.
Parameter properties
| Type: | PSObject |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | AzureRMContext, AzureCredential |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-InputObject
Identity Parameter To construct, see NOTES section for INPUTOBJECT properties and create a hash table.
Parameter properties
| Type: | IPostgreSqlIdentity |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
GetViaIdentity
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | True |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-Name
The name of the server.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | ServerName |
Parameter sets
Get
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-ResourceGroupName
The name of the resource group. The name is case insensitive.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
Get
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
List
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-SubscriptionId
The ID of the target subscription.
Parameter properties
| Type: | String[] |
| Default value: | (Get-AzContext).Subscription.Id |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
List1
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
Get
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
List
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
