ZWRM supports full backups and point-in-time recovery (PITR) for PostgreSQL databases. Backups are stored externally and can be used to restore into a new database instance.
Enable WAL archiving
Before creating backups, enable WAL (Write-Ahead Log) archiving on the database:
zwrm postgres backup enable <name>
zwrm postgres backup disable <name>
Create a backup
zwrm postgres backup create <name>
| Flag | Type | Default | Description |
|---|
--type | string | base | Backup type: base or logical |
Example
zwrm postgres backup create my-db --type base
List backups
zwrm postgres backup list <name>
Example
zwrm postgres backup list my-db
Delete a backup
zwrm postgres backup delete <backup-id>
Deleting a backup is permanent. You won’t be able to restore from it afterward.
Restore a database
Restore creates a new database from a backup. The original database is not modified.
zwrm postgres restore <name> --name <new-name>
| Flag | Type | Default | Description |
|---|
--name | string | — | Name for the restored database (required) |
--backup | string | latest | Specific backup ID to restore from |
--pitr | string | — | Point-in-time recovery target (RFC 3339 timestamp) |
--size | string | same as source | Size preset override: small, medium, large |
Examples
Restore from the latest backup:
zwrm postgres restore my-db --name my-db-restored
zwrm postgres restore my-db --name my-db-restored --backup abc12345
zwrm postgres restore my-db --name my-db-restored --pitr "2026-03-10T14:30:00Z"
PITR requires WAL archiving to be enabled. The target time must fall within the range covered by available WAL segments.
Check restore status
zwrm postgres restore status <restore-id>
