Add ayon backup/restore targets to makefile and manage.ps1 (not just by a project)
Open
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 60
- Forks
- 50
- PR merge metrics
- No merged PRs in 30d
Description
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.sqlto create database dump - copy storage/, addons/, docker-compose.yml and backup.sql to the new machine (and other supporting files)
- run
docker compose up postgreson 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.sqlto 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
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by comparing the existing project dump and restore targets in the Makefile and manage.ps1. Review the proposed docker compose pg_dump and psql commands, along with the listed storage/, addons/, docker-compose.yml, and backup.sql files. Done means adding clearly named targets for complete database backup and restore without populating the database with defaults.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- docker, docker-compose, postgresql, powershell
- Domain
- databases, devops, infrastructure
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100