major_version_upgrade_precheck
Creates, updates, deletes, gets or lists a major_version_upgrade_precheck resource.
Overview
| Name | major_version_upgrade_precheck |
| Type | Resource |
| Id | azure.postgresql_flexible_servers.major_version_upgrade_precheck |
Fields
The following fields are returned by SELECT queries:
- get
- list
| Name | Datatype | Description |
|---|---|---|
id | string | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. |
name | string | The name of the resource. |
createTime | string (date-time) | The time when the precheck was created. |
policyDetails | array | Array of policy validation details. |
precheckResult | object | The detailed result of the precheck operation. |
status | string | The status of the precheck validation. Known values are: "Validating", "Succeeded", "Failed", and "Canceled". (Validating, Succeeded, Failed, Canceled) |
systemData | object | Azure Resource Manager metadata containing createdBy and modifiedBy information. |
targetVersion | string | The target PostgreSQL major version for the upgrade. Known values are: "18", "17", "16", "15", "14", "13", "12", and "11". (18, 17, 16, 15, 14, 13, 12, 11) |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". |
| Name | Datatype | Description |
|---|---|---|
id | string | Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. |
name | string | The name of the resource. |
createTime | string (date-time) | The time when the precheck was created. |
policyDetails | array | Array of policy validation details. |
precheckResult | object | The detailed result of the precheck operation. |
status | string | The status of the precheck validation. Known values are: "Validating", "Succeeded", "Failed", and "Canceled". (Validating, Succeeded, Failed, Canceled) |
systemData | object | Azure Resource Manager metadata containing createdBy and modifiedBy information. |
targetVersion | string | The target PostgreSQL major version for the upgrade. Known values are: "18", "17", "16", "15", "14", "13", "12", and "11". (18, 17, 16, 15, 14, 13, 12, 11) |
type | string | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts". |
Methods
The following methods are available for this resource:
| Name | Accessible by | Required Params | Optional Params | Description |
|---|---|---|---|---|
get | select | resource_group_name, server_name, precheck_validation_id, subscription_id | Gets information about a major version upgrade precheck for a flexible server. | |
list | select | resource_group_name, server_name, subscription_id | Lists major version upgrade prechecks for a flexible server. |
Parameters
Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.
| Name | Datatype | Description |
|---|---|---|
precheck_validation_id | string | The name of the MajorVersionUpgradePrecheckResource. Required. |
resource_group_name | string | The name of the resource group. The name is case insensitive. Required. |
server_name | string | The name of the server. Required. |
subscription_id | string |
SELECT examples
- get
- list
Gets information about a major version upgrade precheck for a flexible server.
SELECT
id,
name,
createTime,
policyDetails,
precheckResult,
status,
systemData,
targetVersion,
type
FROM azure.postgresql_flexible_servers.major_version_upgrade_precheck
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND server_name = '{{ server_name }}' -- required
AND precheck_validation_id = '{{ precheck_validation_id }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;
Lists major version upgrade prechecks for a flexible server.
SELECT
id,
name,
createTime,
policyDetails,
precheckResult,
status,
systemData,
targetVersion,
type
FROM azure.postgresql_flexible_servers.major_version_upgrade_precheck
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND server_name = '{{ server_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;