---
title: "List PostgreSQL databases in a location"
method: GET
path: "/project/{project_id}/location/{location}/postgres"
tags: ["Postgres Database"]
---

# List PostgreSQL databases in a location

`GET /project/{project_id}/location/{location}/postgres`

## Path parameters

- `project_id` string, required
- `location` string, required

## Query parameters

- `start_after` string
- `page_size` integer
- `order_column` string

## Response `200`

A list of Postgres Databases

- object
  - `count` integer, required
  - `items` PostgresDatabase[], required
    - `flavor` string, required — Kind of Postgres database
    - `ha_type` string, required — High availability type
    - `target_server_count` integer, required — Target number of servers (primary + standbys)
    - `id` string, required — ID of the Postgres database
    - `location` string, required — Location of the Postgres database
    - `name` string, required — Name of the Postgres database
    - `state` string, required — State of the Postgres database
    - `storage_size_gib` integer, required — Storage size in GiB
    - `target_storage_size_gib` integer — Desired storage size in GiB
    - `version` '16' | '17' | '18', required — Current Postgres version
    - `target_version` '16' | '17' | '18', required — Target Postgres version
    - `vm_size` string, required — Size of the underlying VM
    - `target_vm_size` string — Desired VM size
    - `ca_certificates` string, nullable — CA certificates of the root CA used to issue postgres server certificates
    - `maintenance_window_start_at` integer, nullable, required — Maintenance window start time
    - `maintenance_window_days` MaintenanceWindowDay[] — Days of the week the maintenance window applies to (empty list means every day)
    - `read_replica` boolean, required — If the database is a read replica or not
    - `parent` string, nullable — Parent Postgres database
    - `fallback_active` boolean, required — Whether the primary server is running on a fallback instance type
    - `tags` PostgresTag[], required — Tags of the Postgres database
      - `key` string, required — Key of the Postgres tag
      - `value` string, required — Value of the Postgres tag
    - `created_at` string, date-time, required — Creation timestamp of the Postgres database

## Other responses

- `default` — An error response

---

[API](https://skmtc.net/ubicloud/apis/clover-api.md) · [All operations](https://skmtc.net/ubicloud/apis/clover-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/ubicloud/clover-api/versions/e8e5db50e9a6/schema)