Create a Postgres database
databases & regions
// what it does
Provisions a PlanetScale for Postgres database instead of the MySQL default. --replicas controls availability (0 = single node, 2+ = HA with failover), and --major-version pins the Postgres major release. Everything downstream — branches, roles, backups — works the same branching model.
// shell
$ pscale database create mydb --engine postgresql --region gcp-asia-northeast3 --replicas 2$ pscale database create mydb --engine postgresql --major-version 17 --region us-east// gotcha
The engine decides which pscale commands apply later: Postgres databases use `role` and `traffic-control` but NOT `connect`, `password`, `deploy-request`, or `keyspace` (those are Vitess-only). A single-node database (--replicas 0) has no failover — fine for side projects, risky for production.