# PostgreSQL v2 API

The <code class="expression">space.vars.ionos\_cloud</code> DBaaS PostgreSQL v2 API (Version 2.0.0) provides a modern, future-proof, and developer-friendly REST interface for provisioning and managing highly available PostgreSQL databases. It features clarified terminology, a stronger resource model, and improved privilege separation compared to the v1 API.

## What Can You Do with the PostgreSQL v2 API?

The <code class="expression">space.vars.ionos\_cloud</code> DBaaS [<mark style="color:blue;">PostgreSQL v2 API</mark>](https://api.ionos.com/docs/postgresql/v2/) provides a modern, developer-friendly interface to manage the complete lifecycle of your highly available PostgreSQL clusters. Using the v2 API, you can:

* **Provision and modify clusters:** Safely create or update your PostgreSQL deployments using the idempotent "Ensure" pattern (`PUT` semantics) on region-specific endpoints.
* **Control geographic data safety:** Query explicit backup Locations to determine exactly where your backups are stored and manage them.
* **Manage independent backups:** Access, filter, and manage your backups as an independent, first-class resource via a dedicated top-level or backups endpoint, making it easier to locate specific restore points.
* **Query supported configurations:** Retrieve centralized lists of supported PostgreSQL versions to plan and configure your cluster deployments.
* **Search and filter resources:** Utilize robust, extensive filtering by state, name, or IDs alongside standardized pagination across every listing endpoint.

## Endpoints

The PostgreSQL v2 APIs are available with the following API endpoints.

| **Data Center**           | **Region** | **Endpoint**                          |
| ------------------------- | ---------- | ------------------------------------- |
| Berlin, Germany           | `de-txl`   | `https://postgresql.de-txl.ionos.com` |
| Frankfurt, Germany        | `de-fra`   | `https://postgresql.de-fra.ionos.com` |
| Paris, France             | `fr-par`   | `https://postgresql.fr-par.ionos.com` |
| Logroño, Spain            | `es-vit`   | `https://postgresql.es-vit.ionos.com` |
| London, United Kingdom    | `gb-lhr`   | `https://postgresql.gb-lhr.ionos.com` |
| Worcester, United Kingdom | `gb-bhx`   | `https://postgresql.gb-bhx.ionos.com` |
| Las Vegas, United States  | `us-las`   | `https://postgresql.us-las.ionos.com` |
| Lenexa, United States     | `us-mci`   | `https://postgresql.us-mci.ionos.com` |
| Newark, United States     | `us-ewr`   | `https://postgresql.us-ewr.ionos.com` |

## Features

* **Cluster provisioning:** It manages the "Cluster" as the top-level logical unit, grouping PostgreSQL server instances, such as primary nodes and standby replicas, into a unified resource. It supports different replication modes, such as `ASYNCHRONOUS` and `STRICTLY_SYNCHRONOUS`.
* **Backup management:** It provides dedicated endpoints for managing backups (read-only, point-in-time backups) and **Backup Locations** that serve as the physical regions where backups are stored, distinct from the cluster location.
* **Ensure pattern:** For updates, the API uses a strict replacement logic (via `PUT` endpoints). When modifying a cluster, the full resource object must be provided. Any data not included in the payload is filled with defaults or left empty, rather than merging with the previous state.
* **Sequential workflow:** The API is designed around a specific lifecycle sequence: plan (retrieve locations), provision (create cluster and credentials), and operate (manage backups and updates). For more information, see [<mark style="color:blue;">Get Started with PostgreSQL v2 API</mark>](/cloud/databases/postgresql/api/v2-api/workflows/get-started.md).

## Quick links

<table data-view="cards"><thead><tr><th></th><th></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td><mark style="color:blue;"><strong>Workflows</strong></mark></td><td>Learn how to inspect an existing cluster, view its configurations, and verify backups.</td><td><a href="/pages/Fp7B3uwtWbxxFoSaqnZv">/pages/Fp7B3uwtWbxxFoSaqnZv</a></td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ionos.com/cloud/databases/postgresql/api/v2-api.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.