Backup AYON database/settings

[robert]

Another question.

How do we backup or even transfer the Ayon database/settings.
i couldn’t find anything in the docs

We’re setting up our server soon with Ayon etc.
But i would like to have an autobackup of the database to another location, so in worst case scenario the server would die, we can load it in on another one.

(preffered we’ve a redundant server with autoswitching etc etc etc, but this is something for next year)

[mustafa_jafar]

@robert

How do we backup or even transfer the Ayon database/settings.

As far as I know, it’s possible to dump the entire database using pg_dump utility in the postgres container.
then for restoring from a backup, you just start the postgres container first on a fresh instance (without server) and use the same method as for restoring projects:

docker compose exec -T postgres psql -U ayon ayon < yourbackupfile.sql

[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.

• 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.

[martin.wacker]

Yep. I use this daily. But I cannot guarantee the redirect will work properly on Windows - they tend to misbehave and try to buffer everything which may be a problem in case of huge dumps - if that ever happens to you, please let me know and we’ll find a workaround

[Des]

• run
  docker compose exec postgres pg_dump -U ayon > backup.sql

This errors out with:

no configuration file provided: not found
This saves an emtpy file in the directory where you run it.

You should update the guide how to properly do this:
Navigate to your ayon docker folder on disk, then run this command.

Users like who didint drink coffe in the morning could get easily a gray hair

Also mentions to if you have your own postgres you dont need docker compose part.

[mustafa_jafar]

@BigRoy has cool GH notes about Backup the Database. you might would like to check it.

https://gist.github.com/BigRoy/bb3613e49ec421acb9d09613d984d98c#dump-entire-database