---
title: "Changes to Create a new PostgreSQL database"
method: POST
path: "/project/{project_id}/location/{location}/postgres/{postgres_database_reference}"
---

# Changes to Create a new PostgreSQL database

`POST /project/{project_id}/location/{location}/postgres/{postgres_database_reference}`

> Every recorded change to this operation, newest first.

## Timeline

Changed in 13 of 66 revisions.

- **2026-10-09** `52d97f23dafe`: 2 info
- **2026-07-14** `0d2405af1fd7`: 1 info
- **2026-07-08** `a8cf54a33de7`: 1 info
- **2026-07-06** `ddf6e87ed1be`: 1 breaking
- **2026-05-22** `576c50424941`: 1 info
- **2026-04-09** `e483b6781a6d`: 1 info
- **2026-03-30** `438e71431435`: 1 breaking, 6 warning, 3 info
- **2026-01-14** `1c05d6ead2a3`: 1 info
- **2026-01-08** `9f8883d5bee5`: 1 info
- **2025-11-26** `269846290b31`: 2 info
- **2025-10-29** `a6e5244b063a`: 2 info
- **2025-10-16** `d6d900441cea`: 3 info
- **2025-10-13** `b25ecb702fca`: 1 info

## Changes

- **2026-10-09** `52d97f23dafe`: 2 info
  - request property `flavor` deprecated
  - response property `allOf[#/components/schemas/PostgresDatabase]/flavor` deprecated
- **2026-07-14** `0d2405af1fd7`: 1 info
  - added the optional property `allOf[#/components/schemas/PostgresDatabase]/maintenance_window_days` to the response with the `200` status
- **2026-07-08** `a8cf54a33de7`: 1 info
  - added the required property `allOf[subschema #2]/private_connection_string` to the response with the `200` status
- **2026-07-06** `ddf6e87ed1be`: 1 breaking
  - the response property `allOf[subschema #2]/maintenance_window_start_at` became nullable for the status `200`
- **2026-05-22** `576c50424941`: 1 info
  - added the required property `allOf[#/components/schemas/PostgresDatabase]/fallback_active` to the response with the `200` status
- **2026-04-09** `e483b6781a6d`: 1 info
  - added the required property `allOf[#/components/schemas/PostgresDatabase]/target_server_count` to the response with the `200` status
- **2026-03-30** `438e71431435`: 1 breaking, 6 warning, 3 info
  - request property `version` was restricted to a list of enum values
  - added the new `16` enum value to the `allOf[#/components/schemas/PostgresDatabase]/target_version` response property for the response status `200`
  - added the new `16` enum value to the `allOf[#/components/schemas/PostgresDatabase]/version` response property for the response status `200`
  - added the new `17` enum value to the `allOf[#/components/schemas/PostgresDatabase]/target_version` response property for the response status `200`
  - added the new `17` enum value to the `allOf[#/components/schemas/PostgresDatabase]/version` response property for the response status `200`
  - added the new `18` enum value to the `allOf[#/components/schemas/PostgresDatabase]/target_version` response property for the response status `200`
  - added the new `18` enum value to the `allOf[#/components/schemas/PostgresDatabase]/version` response property for the response status `200`
  - added the new `16` enum value to the request property `version`
  - added the new `17` enum value to the request property `version`
  - added the new `18` enum value to the request property `version`
- **2026-01-14** `1c05d6ead2a3`: 1 info
  - added the new optional request property `private_subnet_name`
- **2026-01-08** `9f8883d5bee5`: 1 info
  - added the required property `allOf[#/components/schemas/PostgresDatabase]/created_at` to the response with the `200` status
- **2025-11-26** `269846290b31`: 2 info
  - added the new optional request property `pg_config`
  - added the new optional request property `pgbouncer_config`
- **2025-10-29** `a6e5244b063a`: 2 info
  - added the optional property `allOf[subschema #2]/firewall_rules/items/port` to the response with the `200` status
  - the `allOf[subschema #2]/firewall_rules/items/id` response's property pattern was changed from `^pf[0-9a-hj-km-np-tv-z]{24}$` to `^fr[0-9a-hj-km-np-tv-z]{24}$` for the status `200`
- **2025-10-16** `d6d900441cea`: 3 info
  - added the required property `allOf[subschema #2]/hostname` to the response with the `200` status
  - added the required property `allOf[subschema #2]/password` to the response with the `200` status
  - added the required property `allOf[subschema #2]/username` to the response with the `200` status
- **2025-10-13** `b25ecb702fca`: 1 info
  - added the required property `allOf[#/components/schemas/PostgresDatabase]/target_version` to the response with the `200` status

---

[Operation](https://skmtc.dev/ubicloud/apis/clover-api/docs/project/:project_id/location/:location/postgres/:postgres_database_reference/post.md) - [API](https://skmtc.dev/ubicloud/apis/clover-api.md) - [Page](https://skmtc.dev/ubicloud/apis/clover-api/changes/project/:project_id/location/:location/postgres/:postgres_database_reference/post)