ynput / ynput/ayon-docker

Add ayon backup/restore targets to makefile and manage.ps1 (not just by a project)

Open
#31 1 comment 2 reactions 0 assignees View on GitHub

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

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.