Replicas - List By Server
List all the replicas for a given server.
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/replicas?api-version=2022-12-01
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
resource
|
path | True |
string |
The name of the resource group. The name is case insensitive. |
server
|
path | True |
string |
The name of the server. Regex pattern: |
subscription
|
path | True |
string |
The ID of the target subscription. |
api-version
|
query | True |
string |
The API version to use for this operation. |
Responses
Name | Type | Description |
---|---|---|
200 OK |
OK |
|
Other Status Codes |
Error response describing why the operation failed. |
Security
azure_auth
Azure Active Directory OAuth2 Flow
Type:
oauth2
Flow:
implicit
Authorization URL:
https://login.microsoftonline.com/common/oauth2/authorize
Scopes
Name | Description |
---|---|
user_impersonation | impersonate your user account |
Examples
ReplicasListByServer
Sample request
GET https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforPostgreSQL/flexibleServers/sourcepgservername/replicas?api-version=2022-12-01
Sample response
{
"value": [
{
"sku": {
"name": "Standard_D4s_v3",
"tier": "GeneralPurpose"
},
"properties": {
"fullyQualifiedDomainName": "pgtestsvc5rep.postgres.database.azure.com",
"version": "12",
"minorVersion": "6",
"administratorLogin": "cloudsa",
"state": "Ready",
"availabilityZone": "2",
"storage": {
"storageSizeGB": 512
},
"dataEncryption": {
"type": "SystemManaged"
},
"authConfig": {
"activeDirectoryAuth": "Disabled",
"passwordAuth": "Enabled"
},
"backup": {
"backupRetentionDays": 7,
"geoRedundantBackup": "Disabled",
"earliestRestoreDate": "2021-05-27T00:28:17.7279547+00:00"
},
"network": {
"publicNetworkAccess": "Enabled"
},
"highAvailability": {
"mode": "Disabled",
"state": "NotEnabled"
},
"maintenanceWindow": {
"customWindow": "Disabled",
"dayOfWeek": 0,
"startHour": 0,
"startMinute": 0
},
"replicationRole": "AsyncReplica",
"replicaCapacity": 0
},
"location": "westus",
"tags": {
"ElasticServer": "1"
},
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBforPostgreSQL/flexibleServers/pgtestsvc5rep",
"name": "pgtestsvc5rep",
"type": "Microsoft.DBforPostgreSQL/flexibleServers"
}
]
}
Definitions
Name | Description |
---|---|
active |
If Enabled, Azure Active Directory authentication is enabled. |
Arm |
Data encryption type to depict if it is System Managed vs Azure Key vault. |
Auth |
Authentication configuration properties of a server |
Backup |
Backup properties of a server |
created |
The type of identity that created the resource. |
Create |
The mode to create a new PostgreSQL server. |
Data |
Data encryption properties of a server |
Error |
The resource management error additional info. |
Error |
The error detail. |
Error |
Error response |
Geo |
A value indicating whether Geo-Redundant backup is enabled on the server. |
High |
High availability properties of a server |
High |
The HA mode for the server. |
Identity |
the types of identities associated with this resource; currently restricted to 'None and UserAssigned' |
Maintenance |
Maintenance window properties of a server. |
Network |
Network properties of a server. |
password |
If Enabled, Password authentication is enabled. |
Replication |
Used to indicate role of the server in replication set. |
Server |
Represents a server. |
Server |
A state of a HA server that is visible to user. |
Server |
A list of servers. |
Server |
public network access is enabled or not |
Server |
A state of a server that is visible to user. |
Server |
The version of a server. |
Sku |
Sku information related properties of a server. |
Sku |
The tier of the particular SKU, e.g. Burstable. |
Storage |
Storage properties of a server |
system |
Metadata pertaining to creation and last modification of the resource. |
User |
Information describing the identities associated with this application. |
User |
Describes a single user-assigned identity associated with the application. |
activeDirectoryAuthEnum
If Enabled, Azure Active Directory authentication is enabled.
Name | Type | Description |
---|---|---|
Disabled |
string |
|
Enabled |
string |
ArmServerKeyType
Data encryption type to depict if it is System Managed vs Azure Key vault.
Name | Type | Description |
---|---|---|
AzureKeyVault |
string |
|
SystemManaged |
string |
AuthConfig
Authentication configuration properties of a server
Name | Type | Default value | Description |
---|---|---|---|
activeDirectoryAuth |
If Enabled, Azure Active Directory authentication is enabled. |
||
passwordAuth | Enabled |
If Enabled, Password authentication is enabled. |
|
tenantId |
string |
Tenant id of the server. |
Backup
Backup properties of a server
Name | Type | Default value | Description |
---|---|---|---|
backupRetentionDays |
integer |
7 |
Backup retention days for the server. |
earliestRestoreDate |
string |
The earliest restore point time (ISO8601 format) for server. |
|
geoRedundantBackup | Disabled |
A value indicating whether Geo-Redundant backup is enabled on the server. |
createdByType
The type of identity that created the resource.
Name | Type | Description |
---|---|---|
Application |
string |
|
Key |
string |
|
ManagedIdentity |
string |
|
User |
string |
CreateMode
The mode to create a new PostgreSQL server.
Name | Type | Description |
---|---|---|
Create |
string |
|
Default |
string |
|
GeoRestore |
string |
|
PointInTimeRestore |
string |
|
Replica |
string |
|
Update |
string |
DataEncryption
Data encryption properties of a server
Name | Type | Description |
---|---|---|
primaryKeyURI |
string |
URI for the key for data encryption for primary server. |
primaryUserAssignedIdentityId |
string |
Resource Id for the User assigned identity to be used for data encryption for primary server. |
type |
Data encryption type to depict if it is System Managed vs Azure Key vault. |
ErrorAdditionalInfo
The resource management error additional info.
Name | Type | Description |
---|---|---|
info |
object |
The additional info. |
type |
string |
The additional info type. |
ErrorDetail
The error detail.
Name | Type | Description |
---|---|---|
additionalInfo |
The error additional info. |
|
code |
string |
The error code. |
details |
The error details. |
|
message |
string |
The error message. |
target |
string |
The error target. |
ErrorResponse
Error response
Name | Type | Description |
---|---|---|
error |
The error object. |
GeoRedundantBackupEnum
A value indicating whether Geo-Redundant backup is enabled on the server.
Name | Type | Description |
---|---|---|
Disabled |
string |
|
Enabled |
string |
HighAvailability
High availability properties of a server
Name | Type | Default value | Description |
---|---|---|---|
mode | Disabled |
The HA mode for the server. |
|
standbyAvailabilityZone |
string |
availability zone information of the standby. |
|
state |
A state of a HA server that is visible to user. |
HighAvailabilityMode
The HA mode for the server.
Name | Type | Description |
---|---|---|
Disabled |
string |
|
SameZone |
string |
|
ZoneRedundant |
string |
IdentityType
the types of identities associated with this resource; currently restricted to 'None and UserAssigned'
Name | Type | Description |
---|---|---|
None |
string |
|
UserAssigned |
string |
MaintenanceWindow
Maintenance window properties of a server.
Name | Type | Default value | Description |
---|---|---|---|
customWindow |
string |
Disabled |
indicates whether custom window is enabled or disabled |
dayOfWeek |
integer |
0 |
day of week for maintenance window |
startHour |
integer |
0 |
start hour for maintenance window |
startMinute |
integer |
0 |
start minute for maintenance window |
Network
Network properties of a server.
Name | Type | Description |
---|---|---|
delegatedSubnetResourceId |
string |
Delegated subnet arm resource id. This is required to be passed during create, in case we want the server to be VNET injected, i.e. Private access server. During update, pass this only if we want to update the value for Private DNS zone. |
privateDnsZoneArmResourceId |
string |
Private dns zone arm resource id. This is required to be passed during create, in case we want the server to be VNET injected, i.e. Private access server. During update, pass this only if we want to update the value for Private DNS zone. |
publicNetworkAccess |
public network access is enabled or not |
passwordAuthEnum
If Enabled, Password authentication is enabled.
Name | Type | Description |
---|---|---|
Disabled |
string |
|
Enabled |
string |
ReplicationRole
Used to indicate role of the server in replication set.
Name | Type | Description |
---|---|---|
AsyncReplica |
string |
|
GeoAsyncReplica |
string |
|
None |
string |
|
Primary |
string |
Server
Represents a server.
Name | Type | Description |
---|---|---|
id |
string |
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} |
identity |
Describes the identity of the application. |
|
location |
string |
The geo-location where the resource lives |
name |
string |
The name of the resource |
properties.administratorLogin |
string |
The administrator's login name of a server. Can only be specified when the server is being created (and is required for creation). |
properties.administratorLoginPassword |
string |
The administrator login password (required for server creation). |
properties.authConfig |
AuthConfig properties of a server. |
|
properties.availabilityZone |
string |
availability zone information of the server. |
properties.backup |
Backup properties of a server. |
|
properties.createMode |
The mode to create a new PostgreSQL server. |
|
properties.dataEncryption |
Data encryption properties of a server. |
|
properties.fullyQualifiedDomainName |
string |
The fully qualified domain name of a server. |
properties.highAvailability |
High availability properties of a server. |
|
properties.maintenanceWindow |
Maintenance window properties of a server. |
|
properties.minorVersion |
string |
The minor version of the server. |
properties.network |
Network properties of a server. This Network property is required to be passed only in case you want the server to be Private access server. |
|
properties.pointInTimeUTC |
string |
Restore point creation time (ISO8601 format), specifying the time to restore from. It's required when 'createMode' is 'PointInTimeRestore' or 'GeoRestore'. |
properties.replicaCapacity |
integer |
Replicas allowed for a server. |
properties.replicationRole |
Replication role of the server |
|
properties.sourceServerResourceId |
string |
The source server resource ID to restore from. It's required when 'createMode' is 'PointInTimeRestore' or 'GeoRestore' or 'Replica'. This property is returned only for Replica server |
properties.state |
A state of a server that is visible to user. |
|
properties.storage |
Storage properties of a server. |
|
properties.version |
PostgreSQL Server version. |
|
sku |
The SKU (pricing tier) of the server. |
|
systemData |
The system metadata relating to this resource. |
|
tags |
object |
Resource tags. |
type |
string |
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts" |
ServerHAState
A state of a HA server that is visible to user.
Name | Type | Description |
---|---|---|
CreatingStandby |
string |
|
FailingOver |
string |
|
Healthy |
string |
|
NotEnabled |
string |
|
RemovingStandby |
string |
|
ReplicatingData |
string |
ServerListResult
A list of servers.
Name | Type | Description |
---|---|---|
nextLink |
string |
The link used to get the next page of operations. |
value |
Server[] |
The list of flexible servers |
ServerPublicNetworkAccessState
public network access is enabled or not
Name | Type | Description |
---|---|---|
Disabled |
string |
|
Enabled |
string |
ServerState
A state of a server that is visible to user.
Name | Type | Description |
---|---|---|
Disabled |
string |
|
Dropping |
string |
|
Ready |
string |
|
Starting |
string |
|
Stopped |
string |
|
Stopping |
string |
|
Updating |
string |
ServerVersion
The version of a server.
Name | Type | Description |
---|---|---|
11 |
string |
|
12 |
string |
|
13 |
string |
|
14 |
string |
Sku
Sku information related properties of a server.
Name | Type | Description |
---|---|---|
name |
string |
The name of the sku, typically, tier + family + cores, e.g. Standard_D4s_v3. |
tier |
The tier of the particular SKU, e.g. Burstable. |
SkuTier
The tier of the particular SKU, e.g. Burstable.
Name | Type | Description |
---|---|---|
Burstable |
string |
|
GeneralPurpose |
string |
|
MemoryOptimized |
string |
Storage
Storage properties of a server
Name | Type | Description |
---|---|---|
storageSizeGB |
integer |
Max storage allowed for a server. |
systemData
Metadata pertaining to creation and last modification of the resource.
Name | Type | Description |
---|---|---|
createdAt |
string |
The timestamp of resource creation (UTC). |
createdBy |
string |
The identity that created the resource. |
createdByType |
The type of identity that created the resource. |
|
lastModifiedAt |
string |
The timestamp of resource last modification (UTC) |
lastModifiedBy |
string |
The identity that last modified the resource. |
lastModifiedByType |
The type of identity that last modified the resource. |
UserAssignedIdentity
Information describing the identities associated with this application.
Name | Type | Description |
---|---|---|
tenantId |
string |
Tenant id of the server. |
type |
the types of identities associated with this resource; currently restricted to 'None and UserAssigned' |
|
userAssignedIdentities |
<string,
User |
represents user assigned identities map. |
UserIdentity
Describes a single user-assigned identity associated with the application.
Name | Type | Description |
---|---|---|
clientId |
string |
the client identifier of the Service Principal which this identity represents. |
principalId |
string |
the object identifier of the Service Principal which this identity represents. |