---
title: "PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/servers/{serverName}"
method: PUT
path: "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/servers/{serverName}"
tags: ["Servers"]
---

# PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/servers/{serverName}

`PUT /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/servers/{serverName}`

Creates a new server, or will overwrite an existing server.

## Path parameters

- `subscriptionId` string, required
- `resourceGroupName` string, required
- `serverName` string, required

## Query parameters

- `api-version` string, required

## Request body

- ServerForCreate — Represents a server to be created.
  - `sku` Sku — Billing information related properties of a server.
    - `name` string, required — The name of the sku, typically, tier + family + cores, e.g. B_Gen4_1, GP_Gen5_8.
    - `tier` 'Basic' | 'GeneralPurpose' | 'MemoryOptimized' — The tier of the particular SKU, e.g. Basic.
    - `capacity` integer — The scale up/out capacity, representing server's compute units.
    - `size` string — The size code, to be interpreted by resource as appropriate.
    - `family` string — The family of hardware.
  - `properties` ServerPropertiesForCreate, required — The properties used to create a new server.
    - `version` '9.5' | '9.6' | '10' | '10.0' | '10.2' | '11' — The version of a server.
    - `sslEnforcement` 'Enabled' | 'Disabled' — Enable ssl enforcement or not when connect to server.
    - `minimalTlsVersion` 'TLS1_0' | 'TLS1_1' | 'TLS1_2' | 'TLSEnforcementDisabled' — Enforce a minimal Tls version for the server.
    - `storageProfile` StorageProfile — Storage Profile properties of a server
      - `backupRetentionDays` integer — Backup retention days for the server.
      - `geoRedundantBackup` 'Enabled' | 'Disabled' — Enable Geo-redundant or not for server backup.
      - `storageMB` integer — Max storage allowed for a server.
      - `storageAutogrow` 'Enabled' | 'Disabled' — Enable Storage Auto Grow.
    - `createMode` 'Default' | 'PointInTimeRestore' | 'GeoRestore' | 'Replica', required — The mode to create a new server.
  - `location` string, required — The location the resource resides in.
  - `tags` object — Application-specific metadata in the form of key-value pairs.

## Response `200`

OK

- Server — unresolved $ref

## Other responses

- `201` — Created
- `202` — Accepted
- `default` — Error response describing why the operation failed.

## Changes

- **2021-07-02** (2017-12-01-preview) `ae137050faec` — 1 info
  - endpoint added
- **2020-09-09** (2017-12-01-preview) `47f1c002a84e` — 1 breaking
  - api path removed without deprecation

[Change history](https://skmtc.dev/azure/apis/postgresqlmanagementclient/changes/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.DBforPostgreSQL/servers/:serverName/put.md)

---

[API](https://skmtc.dev/azure/apis/postgresqlmanagementclient.md) · [All operations](https://skmtc.dev/azure/apis/postgresqlmanagementclient/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/azure/postgresqlmanagementclient/revisions/ae137050faec/schema)