Backup AYON database/settings

[mustafa_jafar]

Quoted from AYON monthly beginner’s topic - December‘23 | Back up Ayon DB

@mustafa_jafar

Back up Ayon DB

This is some how not related to ayon itself but to postgres container that runs in Ayon stack.

• go to your ayon-docker repo clone.
• run
  docker compose exec postgres pg_dump -U ayon > backup.sql
  to create database dump
• copy storage/ , addons/ , docker-compose.yml and backup.sql to the new machine (and other supporting files)
• run
  docker compose up postgres
  on the new machine to start only the database (if you run the entire stack, it will be populated with defaults, we want to keep it empty for now)
• run
  docker compose exec -T postgres psql -U ayon ayon < backup.sql
  to restore the backup
• start everything using
  docker compose up

Maybe @martin.wacker can add more insights.