Back up PostgreSQL

Back up the PostgreSQL metadata databases. They store users, workspaces, and platform state.

Production recommendation: use a hosted / managed PostgreSQL instance.

It simplifies backups, restores, and upgrades.

What to back up

Deployments use two databases:

• Backend Database

• Core API Database

If you use external PostgreSQL

This is the recommended setup for production.

Back up both application databases using your standard PostgreSQL tooling.

Examples:

• Managed snapshots

• PITR

• pg_dump (logical backup)

If you use the bundled PostgreSQL

Use this for dev/test only.

Back up the database PVCs.

Tools like Velero can back up the namespace.

Common PVC names:

• database-data-1

• database-data-2