A PostgreSQL Database is a database inside a specific PostgreSQL Cluster. It is always created owned by the cluster's root user — access is controlled via grants on PostgreSQL Users, not per-database ownership.

Key concepts

• Belongs to one cluster forever — spec.postgreSqlId is required and immutable, same as PostgreSqlUser

• Extensions are allowlisted — spec.extensions installs PostgreSQL extensions into this database; extensions requiring a shared_preload_libraries change (a restart) are not installable at all — shared_preload_libraries is a reserved key rejected at reconcile, with no tenant-facing path to set it

Allow-listed extensions

btree_gin, btree_gist, citext, cube, earthdistance, fuzzystrmatch, hstore, intarray, ltree, pg_trgm, pgcrypto, postgis, tablefunc, unaccent, uuid-ossp

Anything not on this list — most notably extensions needing shared_preload_libraries such as pg_stat_statements or pg_cron — is rejected here. shared_preload_libraries is a reserved key on PostgreSqlParametersSet too, so there is currently no tenant-facing way to install these extensions.

Examples

A database with an extension installed.

Terraform

Python SDK

kc CLI

---

Related pages

Resource docs

• PostgreSQL Cluster resource docs
• PostgreSQL User resource docs

Examples

• CLI PostgreSQL example
• Terraform PostgreSQL example
• Python SDK PostgreSQL example

More in this section

• Parameter Set