---
title: "Retrieve Postgres instance"
method: GET
path: "/postgres/{postgresId}"
tags: ["Postgres"]
---

# Retrieve Postgres instance

`GET /postgres/{postgresId}`

Retrieve a Postgres instance by ID.

## Path parameters

- `postgresId` string, required

## Response `200`

Successful response

- PostgresDetail
  - `id` string, required
  - `ipAllowList` CidrBlockAndDescription[], required
    - `cidrBlock` string, required
    - `description` string, required — User-provided description of the CIDR block
  - `createdAt` string, date-time, required
  - `updatedAt` string, date-time, required
  - `expiresAt` string, date-time — The time at which the database will be expire. Applies to free tier databases only.
  - `dashboardUrl` string, required — The URL to view the Postgres instance in the Render Dashboard
  - `databaseName` string, required
  - `databaseUser` string, required
  - `environmentId` string
  - `highAvailabilityEnabled` boolean, required
  - `maintenance` Maintenance — unresolved $ref
  - `name` string, required
  - `owner` Owner, required
    - `id` string, required
    - `name` string, required
    - `email` string, required
    - `ipAllowList` CidrBlockAndDescription[]
      - `cidrBlock` string, required
      - `description` string, required — User-provided description of the CIDR block
    - `twoFactorAuthEnabled` boolean — Whether two-factor authentication is enabled for the owner. Only present if `type` is `user`.
    - `type` 'user' | 'team', required
  - `plan` Plan, required — unresolved $ref
  - `diskSizeGB` integer
  - `parameterOverrides` PostgresParameterOverrides
  - `primaryPostgresID` string
  - `region` 'frankfurt' | 'oregon' | 'ohio' | 'singapore' | 'virginia', required — Defaults to "oregon"
  - `readReplicas` ReadReplica[], required
    - `id` string, required — The replica instance identifier.
    - `name` string, required — The display name of the replica instance.
    - `parameterOverrides` PostgresParameterOverrides
  - `role` 'primary' | 'replica', required
  - `status` 'creating' | 'available' | 'unavailable' | 'config_restart' | 'suspended' | 'maintenance_scheduled' | 'maintenance_in_progress' | 'recovery_failed' | 'recovery_in_progress' | 'unknown' | 'updating_instance', required
  - `version` '11' | '12' | '13' | '14' | '15' | '16' | '17' | '18', required — The PostgreSQL version
  - `suspended` 'suspended' | 'not_suspended', required
  - `suspenders` SuspenderType[], required
  - `diskAutoscalingEnabled` boolean, required
  - `connectionPool` string, required — What connection pool to use (if any) out of 'pgbouncer' and 'none'

## Other responses

- `400` — The request could not be understood by the server.
- `401` — Authorization information is missing or invalid.
- `404` — Unable to find the requested resource.
- `429` — Rate limit has been surpassed.
- `500` — An unexpected server error has occurred.
- `503` — Server currently unavailable.

---

[API](https://skmtc.dev/render/apis/render-public-api.md) · [All operations](https://skmtc.dev/render/apis/render-public-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/render/render-public-api/revisions/80e0ff74d033/schema)