Managed PostgreSQL is currently in beta. Do not run production workloads — data loss may occur during this phase.
ZWRM provides managed PostgreSQL databases running in dedicated Firecracker VMs. Each database gets its own isolated environment with persistent storage.
Create a database
zwrm postgres create <name>
| Flag | Type | Default | Description |
|---|
--size | string | small | Size preset: small, medium, or large |
--database | string | postgres | Initial database name |
After creation, you’ll see the connection credentials, connection strings (internal and external), and host information.
Run zwrm postgres presets to see what each size includes.
Example
zwrm postgres create my-db --size medium
Connect to a database
zwrm postgres connect <name>
Shows connection details and ready-to-use psql commands. The database must be running.
List databases
Shows all databases with their ID, name, status, host, size, replica count, and creation time.
Stop and start
Stop a database (data is preserved):
zwrm postgres stop <name>
Start it again:
zwrm postgres start <name>
Destroy a database
zwrm postgres destroy <name>
| Flag | Type | Default | Description |
|---|
--force, -f | bool | false | Skip confirmation prompt |
Destroying a database permanently deletes all data. This cannot be undone.
Size presets
View available presets and their resources:
Each preset defines vCPUs, memory, and storage allocation.