Azure Arc-enabled PostgreSQL Hyperscale enables you to deploy the hyperscale form factor of the Postgres database engine. This service is deployed on the PowerFlex platform from the Azure portal.
All the Azure client tools are installed and upgraded to the latest available version as per the Azure Arc data services , before the Azure Arc data controller is installed. The storage class must be provided during the deployment. By default, the data controller storage class is used.
Perform the following steps to deploy the Azure Arc-enabled PostgreSQL Hyperscale:
Log in to Azure Data CLI with the Azure Arc data controller details to ensure that the data controller is present and running. Enter the namespace, username, and password of the data controller to log in.
PS C:\Users\Admin> Azure Data CLI login
Logged in successfully to `https://192.168.150.122:30080` in namespace `arc`. Setting active context to `arc`.
The Azure Arc-enabled PostgreSQL Hyperscale is created from the Azure portal. The following set of values is passed as input parameters: resource group, custom location, number of worker nodes, compute, storage, and administrative account details. The custom location must be the location on which the data controller is installed.
Two worker nodes are selected in addition to the single coordinator node. The memory size and CPU values are passed as per the requirement.
The storage parameters include data, log and backup volume size, and storage class names.
The deployment of Azure Arc-enabled PostgreSQL Hyperscale is complete.
The deployment of Azure Arc-enabled PostgreSQL Hyperscale is verified by checking the status from the following Azure Data CLI command:
PS C:\Users\Admin\Azure-Data-Certification> Azure Data CLI arc postgres server list
Name Replicas State Workers
------- ---------- ------- ---------
pflexpg 1 Ready 2
The deployed Azure Arc-enabled PostgreSQL Hyperscale server can be monitored and managed from the Azure portal and from Azure Data Studio that is installed on the Windows client machine.