Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add ayon backup/restore targets to makefile and manage.ps1 (not just by a project)Your issue title here #31

Open
2 tasks done
martastain opened this issue Jul 18, 2024 · 0 comments

Comments

@martastain
Copy link
Member

Is there an existing issue for this?

  • I have searched the existing issues.

Please describe the feature you have in mind and explain what the current shortcomings are?

Complete db backup and restore

How would you imagine the implementation of the feature?

  • 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

Are there any labels you wish to add?

  • I have added the relevant labels to the enhancement request.

Describe alternatives you've considered:

No response

Additional context:

keep in mind we already have dump restore targets for projects, so we need to think about names as well

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant