Skip to content

restore database

Jump to bottom
Maxime Labelle edited this page Dec 19, 2023 · 8 revisions

The Postgres database can be restored using the following commands.

Stop application

To safely restore the database, the application must be stopped:

docker compose -f /opt/simplelogin/docker-compose.yaml stop email
docker compose -f /opt/simplelogin/docker-compose.yaml stop app
docker compose -f /opt/simplelogin/docker-compose.yaml stop job-runner

Restore the database

First, wipe and re-create an empty database from template0. Then restore the dump.

docker compose -f /opt/simplelogin/docker-compose.yaml exec postgres \
  psql -U user postgres
> DROP DATABASE simplelogin;
> CREATE DATABASE simplelogin TEMPLATE template0;
> \q

docker compose -f /opt/simplelogin/docker-compose.yaml exec postgres \
  pg_restore -U user -F c --dbname simplelogin /var/lib/postgresql/data/simplelogin.backup

Clone this wiki locally