Create Azure Arc enabled PostgreSQL Hyperscale using Azure Data Studio

This document walks you through the steps for using Azure Data Studio to provision Azure Arc enabled PostgreSQL Hyperscale server groups.

Prerequisites

Before you can proceed with the tasks in this article you need to have:

Note

As a preview feature, the technology presented in this article is subject to Supplemental Terms of Use for Microsoft Azure Previews.

For current limitations, check the known issues in the release notes.

Connect to the Azure Arc data controller

Before you can create an instance, log in to the Azure Arc data controller if you are not already logged in.

azdata login

You will then be prompted for the namespace where the data controller is created, the username, and password to log in to the controller.

If you need to validate the namespace, you can run kubectl get pods -A to get a list of all the namespaces on the cluster.

Username: arcadmin
Password:
Namespace: arc
Logged in successfully to `https://10.0.0.4:30080` in namespace `arc`. Setting active context to `arc`

Preliminary and temporary step for OpenShift users only

Implement this step before moving to the next step. To deploy PostgreSQL Hyperscale server group onto Red Hat OpenShift in a project other than the default, you need to execute the following commands against your cluster to update the security constraints. This command grants the necessary privileges to the service accounts that will run your PostgreSQL Hyperscale server group. The security context constraint (SCC) arc-data-scc is the one you added when you deployed the Azure Arc data controller.

oc adm policy add-scc-to-user arc-data-scc -z <server-group-name> -n <namespace name>

Server-group-name is the name of the server group you will deploy during the next step.

For more details on SCCs in OpenShift, please refer to the OpenShift documentation. You may now implement the next step.

Create an Azure Arc enabled PostgreSQL Hyperscale server group

  1. Launch Azure Data Studio
  2. On the Connections tab, Click on the three dots on the top left and choose "New Deployment"
  3. From the deployment options, select PostgreSQL Hyperscale server group - Azure Arc

    Note

    You may be prompted to install the Azure Data CLI (azdata) here if it is not currently installed.

  4. Accept the Privacy and license terms and click Select at the bottom
  5. In the Deploy PostgreSQL Hyperscale server group - Azure Arc blade, enter the following information:
    • Enter a name for the server group
    • Enter and confirm a password for the postgres administrator user of the server group
    • Select the storage class as appropriate for data
    • Select the storage class as appropriate for logs
    • Select the storage class as appropriate for backups
    • Select the number of worker nodes to provision
  6. Click the Deploy button

This starts the creation of the Azure Arc enabled PostgreSQL Hyperscale server group on the data controller.

In a few minutes, your creation should successfully complete.

Next steps