---
title: Db For Postgresql Server Groups V2
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > Db For Postgresql Server Groups V2
---

# Db For Postgresql Server Groups V2

This table represents the db_for_postgresql_server_groups_v2 resource from Microsoft Azure.

```
azure.db_for_postgresql_server_groups_v2
```

## Fields

| Title                               | ID   | Type          | Data Type                                                                                                                                                                                                                                                                     | Description |
| ----------------------------------- | ---- | ------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- |
| _key                                | core | string        |
| administrator_login                 | core | string        | The administrator's login name of the servers in the cluster.                                                                                                                                                                                                                 |
| administrator_login_password        | core | string        | The password of the administrator login. Required for creation.                                                                                                                                                                                                               |
| citus_version                       | core | string        | The Citus extension version on all cluster servers.                                                                                                                                                                                                                           |
| coordinator_enable_public_ip_access | core | bool          | If public access is enabled on coordinator.                                                                                                                                                                                                                                   |
| coordinator_server_edition          | core | string        | The edition of a coordinator server (default: GeneralPurpose). Required for creation.                                                                                                                                                                                         |
| coordinator_storage_quota_in_mb     | core | int64         | The storage of a server in MB. Required for creation. See https://learn.microsoft.com/azure/cosmos-db/postgresql/resources-compute for more information.                                                                                                                      |
| coordinator_v_cores                 | core | int64         | The vCores count of a server (max: 96). Required for creation. See https://learn.microsoft.com/azure/cosmos-db/postgresql/resources-compute for more information.                                                                                                             |
| earliest_restore_time               | core | string        | The earliest restore point time (ISO8601 format) for the cluster.                                                                                                                                                                                                             |
| enable_ha                           | core | bool          | If high availability (HA) is enabled or not for the cluster.                                                                                                                                                                                                                  |
| enable_shards_on_coordinator        | core | bool          | If distributed tables are placed on coordinator or not. Should be set to 'true' on single node clusters. Requires shard rebalancing after value is changed.                                                                                                                   |
| id                                  | core | string        | Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"                                                                                   |
| location                            | core | string        | The geo-location where the resource lives                                                                                                                                                                                                                                     |
| maintenance_window                  | core | json          | Maintenance window of a cluster.                                                                                                                                                                                                                                              |
| name                                | core | string        | The name of the resource                                                                                                                                                                                                                                                      |
| node_count                          | core | int64         | Worker node count of the cluster. When node count is 0, it represents a single node configuration with the ability to create distributed tables on that node. 2 or more worker nodes represent multi-node configuration. Node count value cannot be 1. Required for creation. |
| node_enable_public_ip_access        | core | bool          | If public access is enabled on worker nodes.                                                                                                                                                                                                                                  |
| node_server_edition                 | core | string        | The edition of a node server (default: MemoryOptimized).                                                                                                                                                                                                                      |
| node_storage_quota_in_mb            | core | int64         | The storage in MB on each worker node. See https://learn.microsoft.com/azure/cosmos-db/postgresql/resources-compute for more information.                                                                                                                                     |
| node_v_cores                        | core | int64         | The compute in vCores on each worker node (max: 104). See https://learn.microsoft.com/azure/cosmos-db/postgresql/resources-compute for more information.                                                                                                                      |
| point_in_time_utc                   | core | string        | Date and time in UTC (ISO8601 format) for cluster restore.                                                                                                                                                                                                                    |
| postgresql_version                  | core | string        | The major PostgreSQL version on all cluster servers.                                                                                                                                                                                                                          |
| preferred_primary_zone              | core | string        | Preferred primary availability zone (AZ) for all cluster servers.                                                                                                                                                                                                             |
| private_endpoint_connections        | core | json          | The private endpoint connections for a cluster.                                                                                                                                                                                                                               |
| provisioning_state                  | core | string        | Provisioning state of the cluster                                                                                                                                                                                                                                             |
| read_replicas                       | core | array<string> | The array of read replica clusters.                                                                                                                                                                                                                                           |
| resource_group                      | core | string        |
| server_names                        | core | json          | The list of server names in the cluster                                                                                                                                                                                                                                       |
| source_location                     | core | string        | The Azure region of source cluster for read replica clusters.                                                                                                                                                                                                                 |
| source_resource_id                  | core | string        | The resource id of source cluster for read replica clusters.                                                                                                                                                                                                                  |
| state                               | core | string        | A state of a cluster/server that is visible to user.                                                                                                                                                                                                                          |
| subscription_id                     | core | string        |
| subscription_name                   | core | string        |
| system_data                         | core | json          | Azure Resource Manager metadata containing createdBy and modifiedBy information.                                                                                                                                                                                              |
| tags                                | core | hstore_csv    |
| type                                | core | string        | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"                                                                                                                                                                     |