Back up & restore

Two things make up a workspace: its database and its file attachments. Back up both.

What to back up

  • Each workspace database (PostgreSQL).
  • The file store — attachments and uploaded documents.
  • Your environment file — so you can rebuild the stack (store it securely, never in the repository).

Back up a database

Use PostgreSQL's tooling from the database container:

docker compose exec db pg_dump -U <db_user> <workspace_db> > workspace.sql

Back up every workspace on a schedule, and copy the dumps off the server (to object storage, for example). Test that a dump restores — an untested backup is a guess.

Restore

docker compose exec -T db psql -U <db_user> <workspace_db> < workspace.sql

Restore the matching file store alongside the database so attachments resolve.

Keep backups encrypted and off-box

A backup on the same server doesn't survive that server. Store encrypted copies elsewhere, and limit who can read them.

← Maintain Email →

Need a hand with this? company@everjust.co — a human answers.