PostgreSQL

Managed PostgreSQL. Supports standard Postgres, Citus (distributed), and PostGIS (geospatial) variants.

Fields

Field	Type	Required	Constraints	Description
`name`	string	Yes
`cpuCores`	float	Yes	0 < value ≤ 2
`memoryMB`	integer	Yes	≤ 4096
`storageGB`	integer	Yes	≤ 100
`dbName`	string	Yes		Database name
`user`	string	Yes		Database user
`password`	string	Yes		Database password
`type`	string	No	`standard`, `citus`, `postgis`	Defaults to `standard`

[[postgres]]
name = "db"
cpuCores = 0.5
memoryMB = 512
storageGB = 10
dbName = "mydb"
user = "app"
password = "secret"

Name	Unit	Description
`POD_CPU`	%	CPU usage
`POD_MEMORY`	MB	Memory usage
`PEAK_CPU`	%	Peak CPU usage
`QUERY_RATE`	queries/sec	Query throughput
`ACTIVE_CONNECTIONS`	count	Number of active connections
`DISK_READ`	MB/s	Disk read throughput
`DISK_WRITE`	MB/s	Disk write throughput
`DISK_IO_UTILIZATION`	%	Disk I/O utilization