These server parameters of the Coordinator node can be set to custom (non-default) values. Search to find parameters.

These server parameters of the Worker nodes can be set to custom (non-default) values. Search to find parameters.

A connection is required to list the databases on this instance.

A connection is required to show and set database engine settings.

A connection to the server is required to show and set database engine settings, which will require the PostgreSQL Extension to be installed.

Admin username

An unexpected error occurred retrieving the config for '{0}'. {1}

An unexpected error occurred retrieving the databases for '{0}'. {1}

An unexpected error occurred retrieving the endpoints for '{0}'. {1}

An unexpected error occurred retrieving the engine settings for '{0}'. {1}

An unexpected error occurred retrieving the registrations for '{0}'. {1}

Apply

Are you sure you want to apply the selected upgrade?

Attempt to get isPassword for unknown variable:{0}

Attempt to get variable value for unknown variable:{0}

Available

Available Upgrades

Available upgrades for this resource are listed below. You can apply upgrades by clicking the upgrade button.

Azure Arc Data Controller

Azure Arc Data Controller Dashboard - {0}

Azure Arc Resources

Azure Database for PostgreSQL - Azure Arc

Backup

Backups

Before doing so, you need to ensure

Browse

BusinessCritical

CPU limit

CPU request

Cancel

Click the new support request button to file a support request in the Azure Portal.

Click the troubleshoot button to open the Azure Arc {0} troubleshooting notebook.

Cluster Context

Cluster Context with name: {0} not found in the Kube config file

Compute

Compute + Storage

Compute Configuration

Condition

Configuration

Configure Retention Policy

Configure retention policy

Confirm the new password

Connect

Connect to Existing Controller

Connect to PostgreSQL server - Azure Arc ({0})

Connect to SQL managed instance - Azure Arc ({0})

Connect to Server

Connection Mode

Connection Strings

Connection string for {0} {0} is the name of the type of connection string (e.g. Java)

Controller Info could not be found with name: {0}

Controller Password

Controller URL

Controller Username

Coordinator

Coordinator Node Parameters

Coordinator endpoint

Copy {0} Connection String to clipboard {0} is the name of the type of connection string (e.g. Java)

Copy {0} to clipboard {0} is the name of the type of value being copied (e.g. Coordinator endpoint)

Could not connect to PostgreSQL server - Azure Arc Instance {0}. {1}

Could not connect to SQL managed instance - Azure Arc Instance {0}. {1}

Could not connect to controller {0}. {1}

Could not find Azure resource for {0}

Could not find controller registration.

Current version

Currently dropping another extension, try again once that is completed.

Currently, only upgrading to the next immediate version is supported.

Dashboard for viewing logs

Dashboard for viewing metrics

Data controller

Data controller is being upgraded. You can check the status of the upgrade by running the following command: 'kubectl get datacontrollers -A'

Database

Database name

Database {0} created

Databases

Databases with available backups are displayed below. Restore databases to this instance or any other instance within the same custom location.

Delete

Deleting instance '{0}'...

Description

Destination Details

Details

Diagnose and solve problems

Direct

Discard

Drop

During a SQL managed instance upgrade, portions of the data control plane such as Custom Resource Definitions (CRDs) and containers may be upgraded. An upgrade of the SQL managed instance will not cause downtime for the data services (SQL Managed Instance or PostgreSQL server).

During a data controller upgrade, portions of the data control plane such as Custom Resource Definitions (CRDs) and containers may be upgraded. An upgrade of the data controller will not cause downtime for the data services (SQL Managed Instance or PostgreSQL server).

Earliest point in time

Editing extensions failed. {0}

Emergency

Enable Trust Server Certificate

Encrypt

Encryption was enabled on this connection, review your SSL and certificate configuration for the target SQL Server, or set 'Trust server certificate' to 'true' in the settings file. Note: A self-signed certificate offers only limited protection and is not a recommended practice for production environments. Do you want to enable 'Trust server certificate' on this connection and retry?

Endpoint

Enter a new password

Enter a non empty password or press escape to exit.

Enter a restore point in the specified time format within given range of earliest and latest restore time.

Enter the required settings for target database name and SQL managed instance. By default, the source managed instance is selected.

Error connecting to controller. {0}

Error encountered while verifying password. {0}

Error getting SQL managed instance version number.

Error getting data controller connection mode.

Error listing Log Analytics workspaces {0}

Error loading cluster contexts. {0}

Error logging into controller - wrong username or password

Error opening dashboard. {0}

Error showing details of SQL managed instance.

Extension '{0}' has been installed.

Extension name

Extensions

Extensions '{0}' added

Extensions '{0}' dropped

External Endpoint

Failed

Failed to acquire password. {0}

Failed to create database {0}. {1}

Failed to delete instance {0}. {1}

Failed to discard user input. {0}

Failed to install extension {0}.

Failed to reset password. {0}

Failed to update instance {0}. {1}

False

Feedback

Fully qualified domain

GeneralPurpose

Grafana Dashboard

Indirect

Installing extension '{0}'...

Instance

Instance '{0}' deleted

Instance '{0}' updated

Invalid config path

Issues Detected

Kibana Dashboard

Kube Config File Path

Last transition

Latest point in time

Learn More.

Learn more about Azure PostgreSQL client interfaces

Learn more about PostgreSQL extensions.

Learn more about database engine settings for Azure Arc-enabled PostgreSQL

Learn more about each release here.

Load extensions

Loading cluster contexts completed

MSSQL

Managed instance admin

Memory limit (in GB)

Memory request (in GB)

Monitor

Name

Namespace

Networking

New Database

New Instance

New support request

No 'contexts' found in the config file: {0}

No Azure Arc controllers are currently connected. Please run the command: 'Connect to Existing Azure Arc Controller' and then try again

No External Endpoint has been configured so this information isn't available.

No context is marked as 'current-context' in the config file: {0}

No current cluster context was found in the kube config file

No extensions listed in configuration.

No instances available

No name field was found in a cluster context in the config file: {0}

No worker pods in this configuration.

No worker server parameters found...

Not Configured

Not Ready

Note that the resource configuration must have been uploaded to Azure first in order to open a support request.

Off

Offline

Online

Open in Azure Portal

Overview

PGSQL

Parameter Name

Password

Password could not be retrieved for controller: {0} and user did not provide a password. Please retry later.

Password reset successfully

Pending

Pod conditions table

Pod containers are ready.

Pod is initialized.

Pod is ready.

Pod is schedulable.

Pods Present

Point in time restore

Point in time restore time window update failed. {0}

Point-In-Time Recovery retention (days)

PostgreSQL by

PostgreSQL provides the ability to extend the functionality of your database by using extensions.

PostgreSQL provides the ability to extend the functionality of your database by using extensions. Extensions allow for bundling multiple related SQL objects together in a single package that can be loaded or removed from your database with a single command. After being loaded in the database, extensions can function like built-in features.

PostgreSQL server - Azure Arc

PostgreSQL server - Azure Arc Dashboard (Preview) - {0}

PostgreSQL version

Preloaded Extensions

Preloaded extensions can now be viewed.

Project Details

Properties

Provide Password to Controller

Provide time in correct format and within range: {0} to {1}

RAM

Ready

Recovering

Recovery Pending

Refresh

Refresh failed. {0}

Refresh node to enter credentials

Region

Release Date

Release Notes

Remember Password

Reset Password

Reset all to default

Reset failed. {0}

Reset to default

Resource Group

Resource health

Resource health can tell you if your resource is running as expected.

Restore

Restore Database

Restore Point Details

Restore a database to an Azure Arc enabled SQL Managed Instance.

Restore point (UTC), in a time format: 'YYYY-MM-DDTHH:MM:SSZ

Restoring

Running

SQL managed instance - Azure Arc

SQL managed instance - Azure Arc Dashboard - {0}

SQL managed instance is being upgraded. You can check the status of the upgrade by running the following command: 'kubectl get sqlmi -A'

Save

Search to filter items...

Security

Select

Select a backup source and provide details. Additional settings will be defaulted where possible based on the selected database.

Select a pod in the dropdown below for detailed health information

Select a pod in the dropdown below for detailed health information.

Select from available client connection strings below.

Select the subscription to manage deployed resources. Use resource groups like folders to organize and manage all your resources.

Server

Server Endpoint

Server group type

Service endpoints

Service endpoints table

Settings

Some extensions must be loaded into PostgreSQL at startup time before they can be used. These preloaded extensions can be viewed and edited below.

Some extensions must be loaded into PostgreSQL at startup time before they can be used. To edit, type in comma separated list of valid extensions: ({0}).

Source Details

Source database

Specify how long you want to keep your point-in-time backups. Customize this for backup availability.

State

Status

Subscription

Subscription ID

Support + troubleshooting

Suspect

Sync Secondary To Commit

Table of preloaded extensions are loading.

Table of preloaded extensions.

The Arc Deployment extension has been replaced by the Arc extension and has been uninstalled.

The Controller URL is necessary if there are multiple clusters with the same namespace - this should generally not be necessary.

The cluster context information specified by config file: {0} and cluster context: {1} is no longer valid. Error is: {2} Do you want to update this information?

The current version is the latest version. No upgrades available.

The name to display in the tree view, this is not applied to the controller itself.

The passwords do not match. Confirm the password or press escape to exit.

The pods listed below are experiencing issues that may affect performance or availability.

The value '{0}' does not match the instance name. Try again or press escape to exit

The version of a SQL Managed Instance can not be newer than the version of its data controller. Currently, only upgrading to the next immediate version is supported.

The {0} extension is required to view engine settings. Do you wish to install it now?

There aren’t any known issues affecting this PostgreSQL instance.

Troubleshoot

True

Trust Server Certificate

Type

USD

Unknown

Unload extensions

Updated {0}

Updating instance '{0}'...

Upgrade

Upgrade Data Controller

Upgrade Management

Upgrade SQL Managed Instance

Upgrading SQL MIAA '{0}' with command 'az sql mi-arc upgrade --name {0} --k8s-namespace {1} --use-k8s'

Upgrading SQL MIAA '{0}' with command 'az sql mi-arc upgrade --name {0} --resource-group {1}'

Upgrading data controller '{0}' with command 'az arcdata dc upgrade --desired-version {1} --name {0} --k8s-namespace {2} --use-k8s'

Upgrading data controller '{0}' with command 'az arcdata dc upgrade --desired-version {1} --name {0} --resource-group {2}'

User cancelled the dialog

Username

Value

Value is expected to be in the range {0} - {1}

Value should be either of the following: ({0}).

Version

Warning! Deleting an instance is permanent and cannot be undone. To delete the instance '{0}' type the name '{0}' below to proceed.

When true (and encrypt=true), SQL Server uses SSL encryption for all data sent between the client and server without validating the server certificate.

When true, SQL Server uses SSL encryption for all data sent between the client and server if the server has a certificate installed.

Worker

Worker Node Parameters

Worker Nodes

Worker node count

Yes

You can check the status of the upgrade by running the following command:

You can scale your Azure Arc-enabled

You can scale your Azure SQL managed instance - Azure Arc by

arc-dc

https://<IP or hostname>:<port>

in your Kubernetes cluster to honor this configuration.

microsoft.azuredatastudio-postgresql

node

nodes

pods ready

scaling compute vCores and memory.

storage per node

there are sufficient resources available

vCores

without downtime and by

{0} backups

{0} copied to clipboard

{0} data

{0} log

{0} vCore

{0} vCores

• {0} ({1} issues)

({0})

1 replica

2 replicas

3 replicas

A comma-separated list of the Postgres extensions that should be loaded on startup. Please refer to the postgres documentation for supported values.

Additional charge per usage. See {0} for more detail.

Admin username

Administrator account

Apply the Azure Hybrid Benefit if you already own a SQL Server License

Auto-upload Logs

Auto-upload Metrics

Azure

Azure Arc

Azure Arc Controllers

Azure Arc data controller

Azure Arc-enabled Managed Instance provides SQL Server access and feature compatibility that can be deployed on the infrastructure of your choice. {0}. By clicking 'Script to notebook' or 'Deploy', I (a) agree to the legal terms and privacy statement(s) associated with the Marketplace offering(s) listed below; (b) authorize Microsoft to bill my current payment method for the fees associated with the offering(s), with the same billing frequency as my Azure subscription; and (c) agree that Microsoft may share my contact, usage and transactional information with the provider(s) of the offering(s) for support, billing and other transactional activities. Microsoft does not provide rights for third-party offerings. For additional details see {1}, {2}, and {3}.

Azure Configuration

Azure Hybrid Benefit discount (in USD)

Azure Marketplace Terms

Azure SQL managed instance - Azure Arc

Azure SQL managed instance - Azure Arc terms and conditions

Azure account

Azure details

Azure information

Azure location

Azure resource group

Azure subscription

Basics

Billable replicas

Business Critical

Business Critical (Unlimited vCores and RAM, advanced high availability)

By clicking 'Script to notebook', I (a) agree to the legal terms and privacy statement(s) associated with the Marketplace offering(s) listed above; (b) authorize Microsoft to bill my current payment method for the fees associated with the offering(s), with the same billing frequency as my Azure subscription; and (c) agree that Microsoft may share my contact, usage and transactional information with the provider(s) of the offering(s) for support, billing and other transactional activities. Microsoft does not provide rights for third-party offerings. For additional details see {0}.

CPU limit

CPU request

CPU vCores Limit

Check the box to indicate this instance will be used for development or testing purposes only. This instance will not be billed.

Choose the Kubernetes configuration template that matches with your Kubernetes distribution. This template provides defaults for storage class, service type, etc.

Choose the config profile

Cluster Name

Cluster context

Cluster name

Compute Configuration

Config profile

Configure retention for point-in-time backups. {0}

Confirm password

Connect to Existing Azure Arc Controller

Connectivity mode

Controller

Controller Configuration

Cores Limit

Cores Request

Cores limit must be greater than or equal to requested cores

Cost Summary

Cost per vCore (in USD)

Create Azure Arc data controller

Create New Azure Arc Controller

Creates an Azure Arc data controller. Ensure that you have run az login before starting this wizard.

Custom Location

Custom location

Data controller custom location

Data controller details

Data controller infrastructure

Data controller name

Data controller namespace

Data controller namespace. Indirect mode only.

Deploy

Deploy Azure SQL managed instance - Azure Arc

Deploy a PostgreSQL Server - Azure Arc (Preview)

Deploy a PostgreSQL server into an Azure Arc environment

Direct

Edit Connection

Enable additional replicas for high availabilty. The compute and storage configuration selected below will be applied to all replicas.

Enable the automatic upload of logs. Direct mode only.

Enable the automatic upload of metrics. Direct mode only.

Engine Version

Enter admin name

Enter instance name

Enter server admin login name

Enter server name

Enter the password that will be used to log in to the metrics and logs dashboards.

Enter the username that will be used for the metrics and logs dashboards.

Estimate Cost of SQL Managed Instance - Azure Arc

Estimated cost per month

Extensions

For development use only

For indirect mode, namespace, name and storage class are required. This name will be used to identify your Arc instance for remote management and monitoring. For direct mode, custom location name is required.

Free

General Purpose

General Purpose (Up to 24 vCores and 128 Gi of RAM, standard high availability)

General settings

High availability

I accept {0} and {1}.

I already have a SQL Server License

Indirect

Infrastructure

Instance name

Instance name must consist of lower case alphanumeric characters or '-', start with a letter, end with an alphanumeric character, and be 13 characters or fewer in length.

Kube config file path

Kubernetes

Kubernetes configuration template

Learn more

Learn more about Azure Arc-enabled Managed Instance

Learn more about PostgreSQL Server - Azure Arc

Loading config profiles

Loading config profiles complete

Loading controllers...

Location

Location is only used for indirect mode deployment. This field will be ignored for direct mode.

Log Analytics primary key

Log Analytics workspace

Log Analytics workspace ID

Manage

Managed Instance admin login

Managed SQL Instance service for app developers in a customer-managed environment

Memory Limit

Memory Request

Memory limit (GB)

Memory limit must be greater than or equal to requested memory

Memory request (GB)

Metrics and Logs Dashboard Credentials

Microsoft Privacy Statement

Name must consist of lower case alphanumeric characters, '-' or '.', start/end with an alphanumeric character and be 253 characters or less in length.

Namespace must consist of lower case alphanumeric characters or '-', start/end with an alphanumeric character, and be 63 characters or fewer in length.

No Azure Arc controllers registered. [Learn More](https://azure.microsoft.com/services/azure-arc/) [Connect Controller](command:arc.connectToController)

Password

Point in time restore

Point in time retention (days)

Port

PostgreSQL Server - Azure Arc (Preview)

PostgreSQL Server - Azure Arc is one of the database engines available as part of Azure Arc-enabled data services and it can be deployed on the infrastructure of your choice. {0}. By clicking 'Script to notebook' or 'Deploy', I (a) agree to the legal terms and privacy statement(s) associated with the Marketplace offering(s) listed below; (b) authorize Microsoft to bill my current payment method for the fees associated with the offering(s), with the same billing frequency as my Azure subscription; and (c) agree that Microsoft may share my contact, usage and transactional information with the provider(s) of the offering(s) for support, billing and other transactional activities. Microsoft does not provide rights for third-party offerings. For additional details see {1}, {2}, and {3}.

PostgreSQL Server - Azure Arc terms and conditions

Provide Azure SQL managed instance parameters

Provide PostgreSQL server parameters

RWX capable

Readable secondary replicas

Refresh

Remove Controller

Requested cores must be less than or equal to cores limit

Requested memory must be less than or equal to memory limit

Resource group

Review your configuration

SQL Connection Information

SQL Connection information

SQL Instance Backup Retention Policy

SQL Instance Settings

SQL Instance settings

SQL Managed Instance - Azure Arc Cost Summary

SQL managed instance - Azure Arc

Script to notebook

Select from existing Kubernetes clusters

Select from the latest vCore service tiers available for SQL Managed Instance - Azure Arc including General Purpose and Business Critical.

Select the subscription to manage deployed resources and costs. Use resource groups like folders to organize and manage all your resources.

Server name

Server name must consist of lower case alphanumeric characters or '-', start with a letter, end with an alphanumeric character, and be 11 characters or fewer in length.

Service Tier

Service type

Specify how long you want to keep your point-in-time backups.

Storage Class

Storage Class (Backups)

Storage Class (Data)

Storage Class (Database logs)

Storage Class (Logs)

Storage settings

Subscription

Support for Azure Arc

Synchronized secondaries required to commit

Target Azure Arc Controller

Terms

That username is disabled; please choose another username.

The Kubernetes cluster must already be arc-enabled with the az connectedk8s connect command. Please use our {0} to learn more.

The cores limit of the managed instance as an integer.

The limit of the capacity of the managed instance as an integer.

The maximum number of CPU cores for the Postgres instance that can be used on the coordinator node. Fractional cores are supported.

The memory limit of the Postgres instance on the coordinator node in GB.

The memory request of the Postgres instance on the coordinator node in GB.

The minimum number of CPU cores that must be available on the coordinator node to schedule the service. Fractional cores are supported.

The name of the cluster. Direct mode only.

The name of the custom location. Direct mode only.

The number of readable secondary replicas.

The number of synchronous replicas required to commit a transaction before the primary replica is allowed to commit. Setting this value to -1 will set the number of required synchronized secondaries to '(# of replicas - 1) / 2', rounded down.

The request for cores of the managed instance as an integer.

The request for the capacity of the managed instance as an integer amount of memory in GBs.

The size of the storage volume to be used for backups in GB.

The size of the storage volume to be used for backups in gibibytes.

The size of the storage volume to be used for data in GB.

The size of the storage volume to be used for data in gibibytes.

The size of the storage volume to be used for database logs in gibibytes.

The size of the storage volume to be used for logs in GB.

The size of the storage volume to be used for logs in gibibytes.

The storage class to be used for Backups. If no value is specified, backups will be stored in same storage class assigned to Data. Must be a RWX capable storage class.

The storage class to be used for all data and logs persistent volumes for all data controller pods that require them.

The storage class to be used for backup persistent volumes

The storage class to be used for data (.mdf). If no value is specified, the default storage class will be used.

The storage class to be used for data persistent volumes

The storage class to be used for database logs (.ldf). If no value is specified, the default storage class will be used.

The storage class to be used for logs (/var/log). If no value is specified, the default storage class will be used.

The storage class to be used for logs persistent volumes

Username

Value must be an integer

Value of 1 is not supported.

Volume Size GB (Backups)

Volume Size GB (Data)

Volume Size GB (Logs)

Volume Size in Gi (Backups)

Volume Size in Gi (Data)

Volume Size in Gi (Database logs)

Volume Size in Gi (Logs)

What is your target existing Kubernetes cluster environment?

by Microsoft

documentation page

pricing details