[PR #82] [MERGED] feat: add automated Postgres backup sidecar with daily pg_dump and retention #84

New issue

Closed

opened 2026-08-13 19:11:27 +02:00 by zaph0d · 0 comments

zaph0d commented

2026-08-13 19:11:27 +02:00

Owner

📋 Pull Request Information

Original PR: https://github.com/niels-emmer/myace/pull/82
Author: @niels-emmer
Created: 8/12/2026
Status: ✅ Merged
Merged: 8/12/2026
Merged by: @niels-emmer

Base: main ← Head: feat/postgres-backups

📝 Commits (1)

8e15d30 feat: add automated Postgres backup sidecar with daily pg_dump and retention

📊 Changes

5 files changed (+117 additions, -18 deletions)

View changed files

📝 .env.example (+11 -0)
📝 .gitignore (+3 -0)
📝 README.md (+49 -18)
📝 docker-compose.yml (+23 -0)
📝 docs/debugging.md (+31 -0)

📄 Description

Summary

Adds a postgres-backup sidecar container to the compose stack that runs pg_dump on a daily schedule with built-in retention. Closes the plan at docs/plans/postgres-backups-plan.md — the backup gap that existed since day one.

Changes

File	Change
`docker-compose.yml`	New `postgres-backup` service (prodrigestivill/postgres-backup-local:16), @daily schedule, 7d/4w/6m retention
`.gitignore`	Ignore `backups/` (host-local dump data)
`.env.example`	Documented SCHEDULE / BACKUP_KEEP_* override vars
`README.md`	Replaced 'no backup mechanism' placeholder with full Backups section
`docs/debugging.md`	Added 'Restoring from a backup dump' entry with password-change gotcha

Testing

docker compose -f docker-compose.yml config validates successfully
docker compose -f docker-compose.yml -f docker-compose.dev.yml config validates — no conflicts with dev overrides
Image prodrigestivill/postgres-backup-local:16 pulled and verified

Checklist

Self-review completed
No new warnings
Tests pass / added (no code changes — compose + docs only)
Documentation updated
Breaking changes: none

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/niels-emmer/myace/pull/82 **Author:** [@niels-emmer](https://github.com/niels-emmer) **Created:** 8/12/2026 **Status:** ✅ Merged **Merged:** 8/12/2026 **Merged by:** [@niels-emmer](https://github.com/niels-emmer) **Base:** `main` ← **Head:** `feat/postgres-backups` --- ### 📝 Commits (1) - [`8e15d30`](https://github.com/niels-emmer/myace/commit/8e15d30fa01b0b719649153cbb35cc1e970ba1b5) feat: add automated Postgres backup sidecar with daily pg_dump and retention ### 📊 Changes **5 files changed** (+117 additions, -18 deletions) <details> <summary>View changed files</summary> 📝 `.env.example` (+11 -0) 📝 `.gitignore` (+3 -0) 📝 `README.md` (+49 -18) 📝 `docker-compose.yml` (+23 -0) 📝 `docs/debugging.md` (+31 -0) </details> ### 📄 Description ## Summary Adds a `postgres-backup` sidecar container to the compose stack that runs `pg_dump` on a daily schedule with built-in retention. Closes the plan at `docs/plans/postgres-backups-plan.md` — the backup gap that existed since day one. ## Changes | File | Change | |------|--------| | `docker-compose.yml` | New `postgres-backup` service (prodrigestivill/postgres-backup-local:16), \@daily schedule, 7d/4w/6m retention | | `.gitignore` | Ignore `backups/` (host-local dump data) | | `.env.example` | Documented SCHEDULE / BACKUP_KEEP_* override vars | | `README.md` | Replaced 'no backup mechanism' placeholder with full Backups section | | `docs/debugging.md` | Added 'Restoring from a backup dump' entry with password-change gotcha | ## Testing - `docker compose -f docker-compose.yml config` validates successfully - `docker compose -f docker-compose.yml -f docker-compose.dev.yml config` validates — no conflicts with dev overrides - Image `prodrigestivill/postgres-backup-local:16` pulled and verified ## Checklist - [x] Self-review completed - [x] No new warnings - [x] Tests pass / added (no code changes — compose + docs only) - [x] Documentation updated - [x] Breaking changes: none --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>

zaph0d

2026-08-13 19:11:27 +02:00