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.
Before you can proceed with the tasks in this article you need to have:
azdata, Azure Data Studio, and Azure CLI.
For Azure Data Studio, install extensions for Azure Data CLI, Azure Arc, and PostgreSQL (depending on data services)
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.
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 -Ato 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
- Launch Azure Data Studio
- On the Connections tab, Click on the three dots on the top left and choose "New Deployment"
- From the deployment options, select PostgreSQL Hyperscale server group - Azure Arc
You may be prompted to install the Azure Data CLI (
azdata) here if it is not currently installed.
- Accept the Privacy and license terms and click Select at the bottom
- 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
- 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.
Read the concepts and How-to guides of Azure Database for PostgreSQL Hyperscale to distribute your data across multiple PostgreSQL Hyperscale nodes and to benefit from all the power of Azure Database for Postgres Hyperscale. :
- Nodes and tables
- Determine application type
- Choose a distribution column
- Table colocation
- Distribute and modify tables
- Design a multi-tenant database*
- Design a real-time analytics dashboard*
* In the documents above, skip the sections Sign in to the Azure portal, & Create an Azure Database for PostgreSQL - Hyperscale (Citus). Implement the remaining steps in your Azure Arc deployment. Those sections are specific to the Azure Database for PostgreSQL Hyperscale (Citus) offered as a PaaS service in the Azure cloud but the other parts of the documents are directly applicable to your Azure Arc enabled PostgreSQL Hyperscale.