---
title: "Get Postgres Cluster"
method: GET
path: "/postgres/{postgres_cluster_id}"
tags: ["Postgres Clusters"]
---

# Get Postgres Cluster

`GET /postgres/{postgres_cluster_id}`

Get details of a specific Managed Postgres cluster.

## Path parameters

- `postgres_cluster_id` string, required

## Response `200`

OK

- ShowPostgresClusterResponse
  - `data` PostgresCluster
    - `attached_apps` PostgresAttachedApp[] — Apps attached to the cluster.
      - `name` string — Attached Fly app name.
    - `cpu_kind` 'shared' | 'performance' — CPU class.
    - `cpus` integer — vCPUs per node.
    - `created_at` string — RFC 3339 creation timestamp.
    - `disk_size_gb` integer — Disk size in gigabytes.
    - `endpoints` PostgresClusterEndpoints
      - `primary` PostgresNodeEndpoints
        - `direct` PostgresEndpoint
          - `host` string — Hostname to connect to.
          - `port` integer — TCP port.
        - `pooler` PostgresEndpoint
          - `host` string — Hostname to connect to.
          - `port` integer — TCP port.
    - `id` string — Cluster ID.
    - `memory_mb` integer — Memory per node in megabytes.
    - `name` string — Cluster name.
    - `organization` OrganizationRef
      - `name` string — Organization name.
      - `slug` string — Organization slug.
    - `pg_major_version` '16' | '17' — Postgres major version.
    - `plan` 'basic' | 'starter' | 'launch' | 'scale' | 'Performance' — Plan slug.
    - `postgis_enabled` boolean — Whether PostGIS support is enabled.
    - `region` string — Fly region code.
    - `replicas` integer — Number of replicas.
    - `status` 'creating' | 'initializing' | 'ready' | 'deleting' | 'deleted' | 'failed' — Current lifecycle status.

## Other responses

- `404` — Cluster not found

---

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