kite postgres¶

Manage PostgreSQL databases.

Aliases: pg

create¶

Create a PostgreSQL database.

kite postgres create <name> [flags]

Flag	Description	Default
`--version`	PostgreSQL version: `14`, `15`, `16`, `17`	`16`
`--memory`	Memory in MB	`1024`
`--cpu`	CPU cores	`0.5`
`--storage`	Storage in GB	`10`
`--storage-type`	Storage type: `nvme`, `ssd`, `hdd`	`nvme`
`--ha`	Enable high availability	`false`
`--replicas`	Number of replicas (with `--ha`)	`2`

# Basic database
kite postgres create mydb

# With custom resources
kite postgres create analytics --memory 2048 --storage 50

# High availability
kite postgres create production --ha --replicas 3

list¶

List PostgreSQL databases.

kite postgres list [--all]

get¶

Get database details.

kite postgres get <name-or-id>

start / stop¶

kite postgres start <name-or-id>
kite postgres stop <name-or-id>

credentials¶

Get database connection credentials.

kite postgres credentials <name-or-id> [--show-password]

Flag	Description
`--show-password`	Show password in output

backup / list-backups¶

kite postgres backup <name-or-id>
kite postgres list-backups <name-or-id>

delete¶

kite postgres delete <name-or-id> [--yes]

Danger

Deleting a database is irreversible. Create a backup first.