Clusters - Update
Memperbarui kluster yang ada. Isi permintaan dapat berisi satu atau beberapa properti dari definisi kluster.
PATCH https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/{clusterName}?api-version=2023-03-02-preview
Parameter URI
| Nama | Dalam | Diperlukan | Jenis | Deskripsi |
|---|---|---|---|---|
|
cluster
|
path | True |
string minLength: 3maxLength: 40 pattern: ^(?![0-9]+$)(?!-)[a-z0-9-]{3,40}(? |
Nama kluster. |
|
resource
|
path | True |
string minLength: 1maxLength: 90 |
Nama grup sumber daya. Nama ini tidak peka huruf besar/kecil. |
|
subscription
|
path | True |
string (uuid) |
ID langganan target. Nilainya harus UUID. |
|
api-version
|
query | True |
string minLength: 1 |
Versi API yang akan digunakan untuk operasi ini. |
Isi Permintaan
| Nama | Jenis | Deskripsi |
|---|---|---|
| identity |
Menjelaskan identitas kluster. |
|
| properties.administratorLoginPassword |
string (password) |
Kata sandi login administrator. Setiap kluster dibuat dengan peran administratif yang telah ditentukan sebelumnya yang disebut 'citus'. |
| properties.citusVersion |
string |
Versi ekstensi Citus di semua server kluster. |
| properties.coordinatorEnablePublicIpAccess |
boolean |
Jika akses publik diaktifkan pada koordinator. |
| properties.coordinatorServerEdition |
string |
Edisi koordinator (default: GeneralPurpose). |
| properties.coordinatorStorageQuotaInMb |
integer (int32) |
Penyimpanan koordinator di MB. |
| properties.coordinatorVCores |
integer (int32) |
Jumlah vCore koordinator (maks: 96). |
| properties.enableHa |
boolean |
Jika ketersediaan tinggi (HA) diaktifkan atau tidak untuk kluster. |
| properties.enableShardsOnCoordinator |
boolean |
Jika tabel terdistribusi ditempatkan pada koordinator atau tidak. Harus diatur ke 'true' pada kluster simpul tunggal. Memerlukan penyeimbangan ulang shard setelah nilai diubah. |
| properties.maintenanceWindow |
Jendela pemeliharaan kluster. |
|
| properties.nodeCount |
integer (int32) |
Jumlah simpul pekerja dari kluster. Ketika jumlah node adalah 0, itu mewakili konfigurasi simpul tunggal dengan kemampuan untuk membuat tabel terdistribusi pada simpul tersebut. 2 simpul pekerja atau lebih mewakili konfigurasi multi-simpul. Nilai jumlah node tidak boleh 1. |
| properties.nodeServerEdition |
string |
Edisi simpul (default: MemoryOptimized). |
| properties.nodeStorageQuotaInMb |
integer (int32) |
Penyimpanan dalam MB pada setiap simpul pekerja. |
| properties.nodeVCores |
integer (int32) |
Komputasi dalam vCore pada setiap simpul pekerja (maks: 104). |
| properties.postgresqlVersion |
string |
Versi PostgreSQL utama di semua server kluster. |
| properties.preferredPrimaryZone |
string |
Zona ketersediaan utama (AZ) pilihan untuk semua server kluster. |
| tags |
object |
Metadata khusus aplikasi dalam bentuk pasangan kunci-nilai. |
Respons
| Nama | Jenis | Deskripsi |
|---|---|---|
| 200 OK |
Operasi Azure berhasil diselesaikan. |
|
| 202 Accepted |
Permintaan telah diterima untuk diproses, tetapi pemrosesan belum selesai. Header
|
|
| Other Status Codes |
Respons kesalahan tak terduga. |
Keamanan
azure_auth
Alur OAuth2 Azure Active Directory.
Jenis:
oauth2
Alur:
implicit
URL Otorisasi:
https://login.microsoftonline.com/common/oauth2/authorize
Cakupan
| Nama | Deskripsi |
|---|---|
| user_impersonation | meniru akun pengguna Anda |
Contoh
| Scale compute up or down |
| Scale out: Add new worker nodes |
| Scale up storage |
| Update multiple configuration settings of the cluster |
| Update or define maintenance window |
Scale compute up or down
Permintaan sampel
Respon sampel
{
"name": "testcluster",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestResourceGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"administratorLogin": "citus",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 2097152,
"coordinatorVCores": 16,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": "2020-09-14T00:00:37.467Z",
"enableHa": false,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Disabled",
"dayOfWeek": 0,
"startHour": 0,
"startMinute": 0
},
"nodeCount": 3,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 2097152,
"nodeVCores": 16,
"passwordEnabled": "enabled",
"postgresqlVersion": "14",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Succeeded",
"readReplicas": [],
"serverNames": [
{
"name": "testcluster1-c",
"fullyQualifiedDomainName": "testcluster1-c.postgres.database.azure.com"
},
{
"name": "testcluster1-w0",
"fullyQualifiedDomainName": "testcluster1-w0.postgres.database.azure.com"
},
{
"name": "testcluster1-w1",
"fullyQualifiedDomainName": "testcluster1-w1.postgres.database.azure.com"
},
{
"name": "testcluster1-w2",
"fullyQualifiedDomainName": "testcluster1-w2.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Ready"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
}
}
Azure-AsyncOperation: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/azureAsyncOperation/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
Location: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/operationResults/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
{
"name": "testcluster",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestResourceGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"administratorLogin": "citus",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 2097152,
"coordinatorVCores": 16,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": "2020-09-14T00:00:37.467Z",
"enableHa": false,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Disabled",
"dayOfWeek": 0,
"startHour": 0,
"startMinute": 0
},
"nodeCount": 3,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 2097152,
"nodeVCores": 16,
"passwordEnabled": "enabled",
"postgresqlVersion": "14",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Succeeded",
"readReplicas": [],
"serverNames": [
{
"name": "testcluster1-c",
"fullyQualifiedDomainName": "testcluster1-c.postgres.database.azure.com"
},
{
"name": "testcluster1-w0",
"fullyQualifiedDomainName": "testcluster1-w0.postgres.database.azure.com"
},
{
"name": "testcluster1-w1",
"fullyQualifiedDomainName": "testcluster1-w1.postgres.database.azure.com"
},
{
"name": "testcluster1-w2",
"fullyQualifiedDomainName": "testcluster1-w2.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Ready"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
}
}
Scale out: Add new worker nodes
Permintaan sampel
Respon sampel
{
"name": "testcluster",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestResourceGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 524288,
"coordinatorVCores": 4,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": null,
"enableGeoBackup": false,
"enableHa": true,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Disabled",
"dayOfWeek": 0,
"startHour": 0,
"startMinute": 0
},
"nodeCount": 2,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 524288,
"nodeVCores": 8,
"passwordEnabled": "enabled",
"postgresqlVersion": "15",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Provisioning",
"readReplicas": [],
"serverNames": [
{
"name": "testcluster-c",
"fullyQualifiedDomainName": "c.testcluster.postgres.database.azure.com"
},
{
"name": "testcluster-w0",
"fullyQualifiedDomainName": "w0.testcluster.postgres.database.azure.com"
},
{
"name": "testcluster-w1",
"fullyQualifiedDomainName": "w1.testcluster.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Provisioning"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
}
}
Azure-AsyncOperation: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/azureAsyncOperation/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
Location: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/operationResults/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
{
"name": "testcluster",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestResourceGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 524288,
"coordinatorVCores": 4,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": null,
"enableGeoBackup": false,
"enableHa": true,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Disabled",
"dayOfWeek": 0,
"startHour": 0,
"startMinute": 0
},
"nodeCount": 2,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 524288,
"nodeVCores": 8,
"passwordEnabled": "enabled",
"postgresqlVersion": "15",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Provisioning",
"readReplicas": [],
"serverNames": [
{
"name": "testcluster-c",
"fullyQualifiedDomainName": "c.testcluster.postgres.database.azure.com"
},
{
"name": "testcluster-w0",
"fullyQualifiedDomainName": "w0.testcluster.postgres.database.azure.com"
},
{
"name": "testcluster-w1",
"fullyQualifiedDomainName": "w1.testcluster.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Provisioning"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
}
}
Scale up storage
Permintaan sampel
Respon sampel
{
"name": "testcluster",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestResourceGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"administratorLogin": "citus",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 2097152,
"coordinatorVCores": 16,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": "2020-09-14T00:00:37.467Z",
"enableHa": false,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Disabled",
"dayOfWeek": 0,
"startHour": 0,
"startMinute": 0
},
"nodeCount": 3,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 2097152,
"nodeVCores": 16,
"passwordEnabled": "enabled",
"postgresqlVersion": "14",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Succeeded",
"readReplicas": [],
"serverNames": [
{
"name": "testcluster1-c",
"fullyQualifiedDomainName": "testcluster1-c.postgres.database.azure.com"
},
{
"name": "testcluster1-w0",
"fullyQualifiedDomainName": "testcluster1-w0.postgres.database.azure.com"
},
{
"name": "testcluster1-w1",
"fullyQualifiedDomainName": "testcluster1-w1.postgres.database.azure.com"
},
{
"name": "testcluster1-w2",
"fullyQualifiedDomainName": "testcluster1-w2.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Ready"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
}
}
Azure-AsyncOperation: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/azureAsyncOperation/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
Location: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/operationResults/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
{
"name": "testcluster",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestResourceGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"administratorLogin": "citus",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 2097152,
"coordinatorVCores": 16,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": "2020-09-14T00:00:37.467Z",
"enableHa": false,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Disabled",
"dayOfWeek": 0,
"startHour": 0,
"startMinute": 0
},
"nodeCount": 3,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 2097152,
"nodeVCores": 16,
"passwordEnabled": "enabled",
"postgresqlVersion": "14",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Succeeded",
"readReplicas": [],
"serverNames": [
{
"name": "testcluster1-c",
"fullyQualifiedDomainName": "testcluster1-c.postgres.database.azure.com"
},
{
"name": "testcluster1-w0",
"fullyQualifiedDomainName": "testcluster1-w0.postgres.database.azure.com"
},
{
"name": "testcluster1-w1",
"fullyQualifiedDomainName": "testcluster1-w1.postgres.database.azure.com"
},
{
"name": "testcluster1-w2",
"fullyQualifiedDomainName": "testcluster1-w2.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Ready"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
}
}
Update multiple configuration settings of the cluster
Permintaan sampel
PATCH https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster?api-version=2023-03-02-preview
{
"properties": {
"administratorLoginPassword": "newpassword",
"coordinatorVCores": 16,
"nodeCount": 4,
"nodeVCores": 16
}
}
Respon sampel
{
"name": "testcluster1",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster1",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"administratorLogin": "citus",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 2097152,
"coordinatorVCores": 16,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": "2020-09-14T00:00:37.467Z",
"enableHa": false,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Disabled",
"dayOfWeek": 0,
"startHour": 0,
"startMinute": 0
},
"nodeCount": 4,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 2097152,
"nodeVCores": 16,
"passwordEnabled": "enabled",
"postgresqlVersion": "14",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Succeeded",
"readReplicas": [
"/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSQL/serverGroupsv2/testreadreplica-01",
"/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSQL/serverGroupsv2/testreadreplica-02"
],
"serverNames": [
{
"name": "testcluster1-c",
"fullyQualifiedDomainName": "testcluster1-c.postgres.database.azure.com"
},
{
"name": "testcluster1-w0",
"fullyQualifiedDomainName": "testcluster1-w0.postgres.database.azure.com"
},
{
"name": "testcluster1-w1",
"fullyQualifiedDomainName": "testcluster1-w1.postgres.database.azure.com"
},
{
"name": "testcluster1-w2",
"fullyQualifiedDomainName": "testcluster1-w2.postgres.database.azure.com"
},
{
"name": "testcluster1-w3",
"fullyQualifiedDomainName": "testcluster1-w2.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Ready"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
},
"tags": {
"additionalProp1": "string",
"additionalProp2": "string",
"additionalProp3": "string"
}
}
Azure-AsyncOperation: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/azureAsyncOperation/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
Location: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/operationResults/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
{
"name": "testcluster1",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster1",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"administratorLogin": "citus",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 2097152,
"coordinatorVCores": 16,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": "2020-09-14T00:00:37.467Z",
"enableHa": false,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Disabled",
"dayOfWeek": 0,
"startHour": 0,
"startMinute": 0
},
"nodeCount": 4,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 2097152,
"nodeVCores": 16,
"passwordEnabled": "enabled",
"postgresqlVersion": "14",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Succeeded",
"readReplicas": [
"/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSQL/serverGroupsv2/testreadreplica-01",
"/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/testrg/providers/Microsoft.DBForPostgreSQL/serverGroupsv2/testreadreplica-02"
],
"serverNames": [
{
"name": "testcluster1-c",
"fullyQualifiedDomainName": "testcluster1-c.postgres.database.azure.com"
},
{
"name": "testcluster1-w0",
"fullyQualifiedDomainName": "testcluster1-w0.postgres.database.azure.com"
},
{
"name": "testcluster1-w1",
"fullyQualifiedDomainName": "testcluster1-w1.postgres.database.azure.com"
},
{
"name": "testcluster1-w2",
"fullyQualifiedDomainName": "testcluster1-w2.postgres.database.azure.com"
},
{
"name": "testcluster1-w3",
"fullyQualifiedDomainName": "testcluster1-w2.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Ready"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
},
"tags": {
"additionalProp1": "string",
"additionalProp2": "string",
"additionalProp3": "string"
}
}
Update or define maintenance window
Permintaan sampel
PATCH https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster?api-version=2023-03-02-preview
{
"properties": {
"maintenanceWindow": {
"customWindow": "Enabled",
"dayOfWeek": 0,
"startHour": 8,
"startMinute": 0
}
}
}
Respon sampel
{
"name": "testcluster",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestResourceGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"administratorLogin": "citus",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 2097152,
"coordinatorVCores": 16,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": "2020-09-14T00:00:37.467Z",
"enableHa": false,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Enabled",
"dayOfWeek": 0,
"startHour": 8,
"startMinute": 0
},
"nodeCount": 2,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 2097152,
"nodeVCores": 16,
"passwordEnabled": "enabled",
"postgresqlVersion": "14",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Succeeded",
"readReplicas": [],
"serverNames": [
{
"name": "testcluster1-c",
"fullyQualifiedDomainName": "testcluster1-c.postgres.database.azure.com"
},
{
"name": "testcluster1-w0",
"fullyQualifiedDomainName": "testcluster1-w0.postgres.database.azure.com"
},
{
"name": "testcluster1-w1",
"fullyQualifiedDomainName": "testcluster1-w1.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Ready"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
}
}
Azure-AsyncOperation: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/azureAsyncOperation/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
Location: https://management.azure.com/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/providers/Microsoft.DBforPostgreSQL/locations/westus/operationResults/e276a03a-1770-4549-86f5-0edffae8997c?api-version=2023-03-02-preview
{
"name": "testcluster",
"type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
"id": "/subscriptions/ffffffff-ffff-ffff-ffff-ffffffffffff/resourceGroups/TestResourceGroup/providers/Microsoft.DBforPostgreSQL/serverGroupsv2/testcluster",
"location": "westus",
"properties": {
"aadAuthEnabled": "disabled",
"administratorLogin": "citus",
"citusVersion": "11.1",
"coordinatorEnablePublicIpAccess": true,
"coordinatorServerEdition": "GeneralPurpose",
"coordinatorStorageQuotaInMb": 2097152,
"coordinatorVCores": 16,
"dataEncryption": {
"type": "SystemManaged"
},
"databaseName": "citus",
"earliestRestoreTime": "2020-09-14T00:00:37.467Z",
"enableHa": false,
"enableShardsOnCoordinator": false,
"maintenanceWindow": {
"customWindow": "Enabled",
"dayOfWeek": 0,
"startHour": 8,
"startMinute": 0
},
"nodeCount": 2,
"nodeEnablePublicIpAccess": false,
"nodeServerEdition": "MemoryOptimized",
"nodeStorageQuotaInMb": 2097152,
"nodeVCores": 16,
"passwordEnabled": "enabled",
"postgresqlVersion": "14",
"preferredPrimaryZone": "1",
"privateEndpointConnections": [],
"provisioningState": "Succeeded",
"readReplicas": [],
"serverNames": [
{
"name": "testcluster1-c",
"fullyQualifiedDomainName": "testcluster1-c.postgres.database.azure.com"
},
{
"name": "testcluster1-w0",
"fullyQualifiedDomainName": "testcluster1-w0.postgres.database.azure.com"
},
{
"name": "testcluster1-w1",
"fullyQualifiedDomainName": "testcluster1-w1.postgres.database.azure.com"
}
],
"sourceResourceId": null,
"state": "Ready"
},
"systemData": {
"createdAt": "2020-01-01T17:18:19.1234567Z",
"createdBy": "user1",
"createdByType": "User",
"lastModifiedAt": "2020-01-02T17:18:19.1234567Z",
"lastModifiedBy": "user2",
"lastModifiedByType": "User"
}
}
Definisi
| Nama | Deskripsi |
|---|---|
|
Aad |
Menunjukkan apakah kluster dibuat menggunakan autentikasi AAD. |
|
Active |
|
|
Auth |
Konfigurasi autentikasi kluster. |
| Cluster |
Mewakili kluster. |
|
Cluster |
Mewakili kluster untuk pembaruan. |
|
created |
Jenis identitas yang membuat sumber daya. |
|
Data |
Properti enkripsi data kluster. |
|
Data |
|
|
Error |
Info tambahan kesalahan manajemen sumber daya. |
|
Error |
Detail kesalahan. |
|
Error |
Respons kesalahan |
|
Identity |
Menjelaskan identitas kluster. |
|
Identity |
|
|
Maintenance |
Jadwalkan pengaturan untuk pembaruan kluster reguler. |
|
Password |
|
|
Password |
Menunjukkan apakah kluster dibuat dengan kata sandi atau menggunakan autentikasi AAD. |
|
Private |
Properti untuk mewakili id sumber daya dari titik akhir privat. |
|
Private |
Status koneksi titik akhir privat. |
|
Private |
Kumpulan informasi tentang status koneksi antara konsumen layanan dan penyedia. |
|
Server |
Objek nama untuk server. |
|
Simple |
Koneksi titik akhir privat. |
|
system |
Metadata yang berkaitan dengan pembuatan dan modifikasi terakhir sumber daya. |
|
User |
Properti identitas yang ditetapkan pengguna |
AadEnabledEnum
Menunjukkan apakah kluster dibuat menggunakan autentikasi AAD.
| Nilai | Deskripsi |
|---|---|
| enabled | |
| disabled |
ActiveDirectoryAuth
| Nilai | Deskripsi |
|---|---|
| enabled | |
| disabled |
AuthConfig
Konfigurasi autentikasi kluster.
| Nama | Jenis | Deskripsi |
|---|---|---|
| activeDirectoryAuth | ||
| passwordAuth |
Cluster
Mewakili kluster.
| Nama | Jenis | Deskripsi |
|---|---|---|
| id |
string (arm-id) |
ID sumber daya yang sepenuhnya memenuhi syarat untuk sumber daya. Misalnya "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}" |
| identity |
Menjelaskan identitas kluster. |
|
| location |
string |
Lokasi geografis tempat sumber daya berada |
| name |
string |
Nama sumber daya |
| properties.aadAuthEnabled |
Menunjukkan apakah kluster dibuat menggunakan autentikasi AAD. |
|
| properties.administratorLogin |
string |
Nama masuk administrator server di kluster. |
| properties.administratorLoginPassword |
string (password) |
Kata sandi login administrator. Diperlukan untuk pembuatan. |
| properties.authConfig |
Konfigurasi autentikasi kluster. |
|
| properties.citusVersion |
string |
Versi ekstensi Citus di semua server kluster. |
| properties.coordinatorEnablePublicIpAccess |
boolean |
Jika akses publik diaktifkan pada koordinator. |
| properties.coordinatorServerEdition |
string |
Edisi server koordinator (default: GeneralPurpose). Diperlukan untuk pembuatan. |
| properties.coordinatorStorageQuotaInMb |
integer (int32) |
Penyimpanan server di MB. Diperlukan untuk pembuatan. Lihat https://learn.microsoft.com/azure/cosmos-db/postgresql/resources-compute untuk informasi selengkapnya. |
| properties.coordinatorVCores |
integer (int32) |
Jumlah vCore server (maks: 96). Diperlukan untuk pembuatan. Lihat https://learn.microsoft.com/azure/cosmos-db/postgresql/resources-compute untuk informasi selengkapnya. |
| properties.dataEncryption |
Properti enkripsi data kluster. |
|
| properties.databaseName |
string |
Nama database kluster. Hanya satu database per kluster yang didukung. |
| properties.earliestRestoreTime |
string (date-time) |
Waktu titik pemulihan paling awal (format ISO8601) untuk kluster. |
| properties.enableGeoBackup |
boolean |
Jika cadangan kluster disimpan di wilayah Azure lain selain salinan cadangan yang disimpan di wilayah kluster. Diaktifkan hanya pada saat pembuatan kluster. |
| properties.enableHa |
boolean |
Jika ketersediaan tinggi (HA) diaktifkan atau tidak untuk kluster. |
| properties.enableShardsOnCoordinator |
boolean |
Jika tabel terdistribusi ditempatkan pada koordinator atau tidak. Harus diatur ke 'true' pada kluster simpul tunggal. Memerlukan penyeimbangan ulang shard setelah nilai diubah. |
| properties.maintenanceWindow |
Jendela pemeliharaan kluster. |
|
| properties.nodeCount |
integer (int32) |
Jumlah simpul pekerja dari kluster. Ketika jumlah node adalah 0, itu mewakili konfigurasi simpul tunggal dengan kemampuan untuk membuat tabel terdistribusi pada simpul tersebut. 2 simpul pekerja atau lebih mewakili konfigurasi multi-simpul. Nilai jumlah node tidak boleh 1. Diperlukan untuk pembuatan. |
| properties.nodeEnablePublicIpAccess |
boolean |
Jika akses publik diaktifkan pada simpul pekerja. |
| properties.nodeServerEdition |
string |
Edisi server simpul (default: MemoryOptimized). |
| properties.nodeStorageQuotaInMb |
integer (int32) |
Penyimpanan dalam MB pada setiap simpul pekerja. Lihat https://learn.microsoft.com/azure/cosmos-db/postgresql/resources-compute untuk informasi selengkapnya. |
| properties.nodeVCores |
integer (int32) |
Komputasi dalam vCore pada setiap simpul pekerja (maks: 104). Lihat https://learn.microsoft.com/azure/cosmos-db/postgresql/resources-compute untuk informasi selengkapnya. |
| properties.passwordEnabled |
Menunjukkan apakah kluster dibuat dengan kata sandi atau menggunakan autentikasi AAD. |
|
| properties.pointInTimeUTC |
string (date-time) |
Tanggal dan waktu dalam format UTC (ISO8601) untuk pemulihan kluster. |
| properties.postgresqlVersion |
string |
Versi PostgreSQL utama di semua server kluster. |
| properties.preferredPrimaryZone |
string |
Zona ketersediaan utama (AZ) pilihan untuk semua server kluster. |
| properties.privateEndpointConnections |
Koneksi titik akhir privat untuk kluster. |
|
| properties.provisioningState |
string |
Status provisi kluster |
| properties.readReplicas |
string[] |
Array kluster replika baca. |
| properties.serverNames |
Daftar nama server dalam kluster |
|
| properties.sourceLocation |
string |
Wilayah Azure kluster sumber untuk kluster replika baca. |
| properties.sourceResourceId |
string |
Id sumber daya kluster sumber untuk kluster replika baca. |
| properties.state |
string |
Status kluster/server yang terlihat oleh pengguna. |
| systemData |
Metadata Azure Resource Manager yang berisi informasi createBy dan modifiedBy. |
|
| tags |
object |
Tag sumber daya. |
| type |
string |
Jenis sumber daya. Misalnya, "Microsoft.Compute/virtualMachines" atau "Microsoft.Storage/storageAccounts" |
ClusterForUpdate
Mewakili kluster untuk pembaruan.
| Nama | Jenis | Deskripsi |
|---|---|---|
| identity |
Menjelaskan identitas kluster. |
|
| properties.administratorLoginPassword |
string (password) |
Kata sandi login administrator. Setiap kluster dibuat dengan peran administratif yang telah ditentukan sebelumnya yang disebut 'citus'. |
| properties.citusVersion |
string |
Versi ekstensi Citus di semua server kluster. |
| properties.coordinatorEnablePublicIpAccess |
boolean |
Jika akses publik diaktifkan pada koordinator. |
| properties.coordinatorServerEdition |
string |
Edisi koordinator (default: GeneralPurpose). |
| properties.coordinatorStorageQuotaInMb |
integer (int32) |
Penyimpanan koordinator di MB. |
| properties.coordinatorVCores |
integer (int32) |
Jumlah vCore koordinator (maks: 96). |
| properties.enableHa |
boolean |
Jika ketersediaan tinggi (HA) diaktifkan atau tidak untuk kluster. |
| properties.enableShardsOnCoordinator |
boolean |
Jika tabel terdistribusi ditempatkan pada koordinator atau tidak. Harus diatur ke 'true' pada kluster simpul tunggal. Memerlukan penyeimbangan ulang shard setelah nilai diubah. |
| properties.maintenanceWindow |
Jendela pemeliharaan kluster. |
|
| properties.nodeCount |
integer (int32) |
Jumlah simpul pekerja dari kluster. Ketika jumlah node adalah 0, itu mewakili konfigurasi simpul tunggal dengan kemampuan untuk membuat tabel terdistribusi pada simpul tersebut. 2 simpul pekerja atau lebih mewakili konfigurasi multi-simpul. Nilai jumlah node tidak boleh 1. |
| properties.nodeEnablePublicIpAccess |
boolean |
Jika akses publik diaktifkan pada simpul pekerja. |
| properties.nodeServerEdition |
string |
Edisi simpul (default: MemoryOptimized). |
| properties.nodeStorageQuotaInMb |
integer (int32) |
Penyimpanan dalam MB pada setiap simpul pekerja. |
| properties.nodeVCores |
integer (int32) |
Komputasi dalam vCore pada setiap simpul pekerja (maks: 104). |
| properties.postgresqlVersion |
string |
Versi PostgreSQL utama di semua server kluster. |
| properties.preferredPrimaryZone |
string |
Zona ketersediaan utama (AZ) pilihan untuk semua server kluster. |
| tags |
object |
Metadata khusus aplikasi dalam bentuk pasangan kunci-nilai. |
createdByType
Jenis identitas yang membuat sumber daya.
| Nilai | Deskripsi |
|---|---|
| User | |
| Application | |
| ManagedIdentity | |
| Key |
DataEncryption
Properti enkripsi data kluster.
| Nama | Jenis | Deskripsi |
|---|---|---|
| primaryKeyUri |
string |
URI untuk kunci di keyvault untuk enkripsi data server utama. |
| primaryUserAssignedIdentityId |
string |
Id Sumber Daya untuk identitas yang ditetapkan Pengguna yang akan digunakan untuk enkripsi data server utama. |
| type |
DataEncryptionType
| Nilai | Deskripsi |
|---|---|
| AzureKeyVault | |
| SystemAssigned |
ErrorAdditionalInfo
Info tambahan kesalahan manajemen sumber daya.
| Nama | Jenis | Deskripsi |
|---|---|---|
| info |
object |
Info tambahan. |
| type |
string |
Jenis info tambahan. |
ErrorDetail
Detail kesalahan.
| Nama | Jenis | Deskripsi |
|---|---|---|
| additionalInfo |
Info tambahan kesalahan. |
|
| code |
string |
Kode kesalahan. |
| details |
Detail kesalahan. |
|
| message |
string |
Pesan kesalahan. |
| target |
string |
Target kesalahan. |
ErrorResponse
Respons kesalahan
| Nama | Jenis | Deskripsi |
|---|---|---|
| error |
Objek kesalahan. |
IdentityProperties
Menjelaskan identitas kluster.
| Nama | Jenis | Deskripsi |
|---|---|---|
| type | ||
| userAssignedIdentities |
<string,
User |
Kumpulan identitas yang ditetapkan pengguna yang terkait dengan sumber daya. Kunci kamus userAssignedIdentities akan menjadi id sumber daya ARM dalam formulir: '/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.ManagedIdentity/userAssignedIdentities/{identityName}. Nilai kamus dapat berupa objek kosong ({}) dalam permintaan. |
IdentityType
| Nilai | Deskripsi |
|---|---|
| UserAssigned | |
| SystemAssigned |
MaintenanceWindow
Jadwalkan pengaturan untuk pembaruan kluster reguler.
| Nama | Jenis | Deskripsi |
|---|---|---|
| customWindow |
string |
Menunjukkan apakah jendela pemeliharaan kustom diaktifkan atau tidak. |
| dayOfWeek |
integer (int32) |
Hari yang disukai dalam seminggu untuk jendela pemeliharaan. |
| startHour |
integer (int32) |
Mulai jam dalam hari yang disukai dalam seminggu untuk jendela pemeliharaan. |
| startMinute |
integer (int32) |
Mulai menit dalam jam mulai untuk jendela pemeliharaan. |
PasswordAuth
| Nilai | Deskripsi |
|---|---|
| enabled | |
| disabled |
PasswordEnabledEnum
Menunjukkan apakah kluster dibuat dengan kata sandi atau menggunakan autentikasi AAD.
| Nilai | Deskripsi |
|---|---|
| enabled | |
| disabled |
PrivateEndpointProperty
Properti untuk mewakili id sumber daya dari titik akhir privat.
| Nama | Jenis | Deskripsi |
|---|---|---|
| id |
string |
Id sumber daya titik akhir privat. |
PrivateEndpointServiceConnectionStatus
Status koneksi titik akhir privat.
| Nilai | Deskripsi |
|---|---|
| Pending | |
| Approved | |
| Rejected |
PrivateLinkServiceConnectionState
Kumpulan informasi tentang status koneksi antara konsumen layanan dan penyedia.
| Nama | Jenis | Deskripsi |
|---|---|---|
| actionsRequired |
string |
Pesan yang menunjukkan apakah perubahan pada penyedia layanan memerlukan pembaruan pada konsumen. |
| description |
string |
Alasan persetujuan/penolakan koneksi. |
| status |
Menunjukkan apakah koneksi telah Disetujui/Ditolak/Dihapus oleh pemilik layanan. |
ServerNameItem
Objek nama untuk server.
| Nama | Jenis | Deskripsi |
|---|---|---|
| fullyQualifiedDomainName |
string |
Nama domain server yang sepenuhnya memenuhi syarat. |
| name |
string |
Nama server. |
SimplePrivateEndpointConnection
Koneksi titik akhir privat.
| Nama | Jenis | Deskripsi |
|---|---|---|
| id |
string (arm-id) |
ID sumber daya yang sepenuhnya memenuhi syarat untuk sumber daya. Misalnya "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}" |
| name |
string |
Nama sumber daya |
| properties.groupIds |
string[] |
Id grup koneksi titik akhir privat. |
| properties.privateEndpoint |
Titik akhir privat tempat koneksi berada. |
|
| properties.privateLinkServiceConnectionState |
Kumpulan informasi tentang status koneksi antara konsumen layanan dan penyedia. |
|
| systemData |
Metadata Azure Resource Manager yang berisi informasi createBy dan modifiedBy. |
|
| type |
string |
Jenis sumber daya. Misalnya, "Microsoft.Compute/virtualMachines" atau "Microsoft.Storage/storageAccounts" |
systemData
Metadata yang berkaitan dengan pembuatan dan modifikasi terakhir sumber daya.
| Nama | Jenis | Deskripsi |
|---|---|---|
| createdAt |
string (date-time) |
Tanda waktu pembuatan sumber daya (UTC). |
| createdBy |
string |
Identitas yang membuat sumber daya. |
| createdByType |
Jenis identitas yang membuat sumber daya. |
|
| lastModifiedAt |
string (date-time) |
Tanda waktu modifikasi terakhir sumber daya (UTC) |
| lastModifiedBy |
string |
Identitas yang terakhir mengubah sumber daya. |
| lastModifiedByType |
Jenis identitas yang terakhir memodifikasi sumber daya. |
UserAssignedIdentity
Properti identitas yang ditetapkan pengguna
| Nama | Jenis | Deskripsi |
|---|---|---|
| clientId |
string (uuid) |
ID klien dari identitas yang ditetapkan. |
| principalId |
string (uuid) |
ID utama identitas yang ditetapkan. |