# Source: https://docs.datadoghq.com/ddsql_reference/data_directory/azure/azure.postgresql_server.dataset.md

---
title: Azure Database for PostgreSQL Server
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > Azure Database for PostgreSQL Server
---

# Azure Database for PostgreSQL Server

Azure Database for PostgreSQL Server is a fully managed relational database service based on the open-source PostgreSQL engine. It provides built-in high availability, automated backups, scaling, and security features without the need for manual database management. This service is ideal for running PostgreSQL workloads in the cloud with minimal administrative overhead.

```
azure.postgresql_server
```

## Fields

| Title                       | ID   | Type       | Data Type                                                                                                                                                                                                                                                                                                                                                                                                                | Description |
| --------------------------- | ---- | ---------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ----------- |
| _key                        | core | string     |
| administrator_login         | core | string     | Name of the login designated as the first password based administrator assigned to your instance of PostgreSQL. Must be specified the first time that you enable password based authentication on a server. Once set to a given value, it cannot be changed for the rest of the life of a server. If you disable password based authentication on a server which had it enabled, this password based role isn't deleted. |
| byok_enforcement            | core | string     | Status showing whether the server data encryption is enabled with customer-managed keys.                                                                                                                                                                                                                                                                                                                                 |
| earliest_restore_date       | core | string     | Earliest restore point creation time (ISO8601 format)                                                                                                                                                                                                                                                                                                                                                                    |
| firewall_rules              | core | json       |
| fully_qualified_domain_name | core | string     | Fully qualified domain name of a flexible server.                                                                                                                                                                                                                                                                                                                                                                        |
| id                          | core | string     | Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"                                                                                                                                                                                                                              |
| identity                    | core | json       | Identities associated with a flexible server.                                                                                                                                                                                                                                                                                                                                                                            |
| infrastructure_encryption   | core | string     | Status showing whether the server enabled infrastructure encryption.                                                                                                                                                                                                                                                                                                                                                     |
| location                    | core | string     | The geo-location where the resource lives                                                                                                                                                                                                                                                                                                                                                                                |
| master_server_id            | core | string     | The master server id of a replica server.                                                                                                                                                                                                                                                                                                                                                                                |
| minimal_tls_version         | core | string     | Enforce a minimal Tls version for the server.                                                                                                                                                                                                                                                                                                                                                                            |
| name                        | core | string     | The name of the resource                                                                                                                                                                                                                                                                                                                                                                                                 |
| public_network_access       | core | string     | Whether or not public network access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'                                                                                                                                                                                                                                                                                     |
| replica_capacity            | core | int64      | Maximum number of read replicas allowed for a flexible server.                                                                                                                                                                                                                                                                                                                                                           |
| replication_role            | core | string     | Role of the flexible server in a replication set.                                                                                                                                                                                                                                                                                                                                                                        |
| resource_group              | core | string     |
| server_configs              | core | json       |
| sku                         | core | json       | Compute information of a flexible server.                                                                                                                                                                                                                                                                                                                                                                                |
| ssl_enforcement             | core | string     | Enable ssl enforcement or not when connect to server.                                                                                                                                                                                                                                                                                                                                                                    |
| storage_profile             | core | json       | Storage profile of a server.                                                                                                                                                                                                                                                                                                                                                                                             |
| subscription_id             | core | string     |
| subscription_name           | core | string     |
| tags                        | core | hstore_csv |
| type                        | core | string     | The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"                                                                                                                                                                                                                                                                                                                |
| user_visible_state          | core | string     | A state of a server that is visible to user.                                                                                                                                                                                                                                                                                                                                                                             |
| version                     | core | string     | Major version of PostgreSQL database engine.                                                                                                                                                                                                                                                                                                                                                                             |