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

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

# PostgreSQL Flexible Server

This table represents the PostgreSQL Flexible Server resource from Microsoft Azure.

```
azure.postgresql_flexible_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. |
| availability_zone           | core | string     | Availability zone of a flexible server.                                                                                                                                                                                                                                                                                                                                                                                  |
| backup                      | core | json       | Backup properties of a flexible server.                                                                                                                                                                                                                                                                                                                                                                                  |
| create_mode                 | core | string     | Creation mode of a new flexible server.                                                                                                                                                                                                                                                                                                                                                                                  |
| fully_qualified_domain_name | core | string     | Fully qualified domain name of a flexible server.                                                                                                                                                                                                                                                                                                                                                                        |
| high_availability           | core | json       | High availability properties of a flexible server.                                                                                                                                                                                                                                                                                                                                                                       |
| 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 properties of a flexible server.                                                                                                                                                                                                                                                                                                                                                                      |
| minor_version               | core | string     | Minor version of PostgreSQL database engine.                                                                                                                                                                                                                                                                                                                                                                             |
| name                        | core | string     | The name of the resource                                                                                                                                                                                                                                                                                                                                                                                                 |
| network                     | core | json       | Network properties of a flexible server. Only required if you want your server to be integrated into a virtual network provided by customer.                                                                                                                                                                                                                                                                             |
| point_in_time_utc           | core | string     | Creation time (in ISO8601 format) of the backup which you want to restore in the new flexible server. It's required when 'createMode' is 'PointInTimeRestore', 'GeoRestore', or 'ReviveDropped'.                                                                                                                                                                                                                         |
| resource_group              | core | string     |
| sku                         | core | json       | Compute tier and size of a flexible server.                                                                                                                                                                                                                                                                                                                                                                              |
| source_server_resource_id   | core | string     | Identifier of the flexible server to be used as the source of the new flexible server. Required when 'createMode' is 'PointInTimeRestore', 'GeoRestore', 'Replica', or 'ReviveDropped'. This property is returned only when the target flexible server is a read replica.                                                                                                                                                |
| state                       | core | string     | Possible states of a flexible server.                                                                                                                                                                                                                                                                                                                                                                                    |
| storage                     | core | json       | Storage properties of a flexible server.                                                                                                                                                                                                                                                                                                                                                                                 |
| 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"                                                                                                                                                                                                                                                                                                                |
| version                     | core | string     | Major version of PostgreSQL database engine.                                                                                                                                                                                                                                                                                                                                                                             |