sabaoth postgres list

Lists the PostgreSQL services in the effective organization. Returns one page unless you pass --all.

sabaoth postgres list [--page <n>] [--page-size <n>] [--all] [--org <org-id>] [--json]

Flags

integer

Page number to fetch, starting from 1. Defaults to the first page.

integer

Number of services per page, 1 or more. If left out, the server’s default is used.

boolean

default:"false"

Fetch every page instead of just one.

string

Organization to act in, instead of the selected one. See Organizations and context.

boolean

default:"false"

Print the result as JSON on stdout.

Examples

sabaoth postgres list
sabaoth postgres list --page 2 --page-size 50
sabaoth postgres list --all --json
sabaoth postgres list --org org_abc

Output

$ sabaoth postgres list
ID       NAME       STATUS        VERSION  CPU   MEMORY  STORAGE  REPLICAS
clu_abc  orders-db  ready         16       500m  1024Mi  10Gi     1
clu_def  analytics  provisioning  17       2000m 4096Mi  40Gi     1

Showing 2 of 2.

CPU is in millicores (1000m is one vCPU), memory in MiB and storage in GiB. With --json:

{
  "items": [
    {
      "id": "clu_abc",
      "name": "orders-db",
      "status": "ready",
      "postgres_version": "16",
      "cpu_millicores": 500,
      "memory_mb": 1024,
      "storage_gb": 10,
      "replicas": 1,
      "created_at": "2026-01-01T00:00:00Z"
    }
  ],
  "page": 1,
  "page_size": 20,
  "total": 1
}

Field	Description
`items`	The services on this page (or every service, with `--all`).
`page`, `page_size`	The page returned and its size.
`total`	Total services in the organization.

Connection details, networking and backup settings aren’t included in the list. Use sabaoth postgres get for those.

Behavior

One page by default. Showing 20 of 45. means there are more pages. Use --page or --all to see them.
--all never returns a partial list as if it were complete. If an error happens part-way through, the whole command fails. If it stops at the CLI’s internal page limit, you get a warning that the list may be incomplete (in --json mode, inside a warnings array).

Errors

Code	Exit	Meaning
`INVALID_PAGE`	2	`--page` must be a whole number of 1 or more.
`INVALID_PAGE_SIZE`	2	`--page-size` must be a whole number of 1 or more.

You may also see authentication, organization and network errors. See Error codes.

Get Started

Account

Organizations

PostgreSQL

Backups

Reference

Flags

Examples

Output

Behavior

Errors

Flags

Examples

Output

Behavior

Errors

Related