BPPP/smb-online
2
0
Fork 0
Code Issues 15 Pull Requests Actions Packages Projects Releases Wiki Activity

Daily backups of Postgres (smb-db), n8n, and Gitea + offsite copy + restore test #4

New Issue
Open
opened 2026-07-16 10:37:37 +02:00 by mivanchenko · 1 comment
mivanchenko commented 2026-07-16 10:37:37 +02:00
Owner
Copy Link
Copy Source

No automated backups today. Stand up a daily backup job on the homelab covering:

  • smb-db Postgres volume (CRM source of truth)
  • n8n data (workflows + credentials)
  • Gitea (repos + gitea-db-1 Postgres dump)

Requirements: scheduled (cron/systemd timer), retained N days, copied off-box (offsite/other host), and a documented + tested restore. A backup that's never restored isn't a backup.

Acceptance: a restore drill brings back the CRM DB and at least one n8n workflow on a scratch target.

No automated backups today. Stand up a daily backup job on the homelab covering: - `smb-db` Postgres volume (CRM source of truth) - n8n data (workflows + credentials) - Gitea (repos + `gitea-db-1` Postgres dump) **Requirements:** scheduled (cron/systemd timer), retained N days, **copied off-box** (offsite/other host), and a **documented + tested restore**. A backup that's never restored isn't a backup. **Acceptance:** a restore drill brings back the CRM DB and at least one n8n workflow on a scratch target.
mivanchenko added the opsinfra labels 2026-07-16 10:37:37 +02:00
mivanchenko commented 2026-07-16 10:41:27 +02:00
Author
Owner
Copy Link
Copy Source

Partial: the smb-db Postgres portion already exists — deploy/backup/smb-db-backup.sh (pg_dump + gzip, 14-day retention, cron on the homelab). Remaining scope for this issue: n8n data + Gitea (repos + gitea-db-1 dump) coverage, an offsite copy, and a documented + tested restore.

Partial: the smb-db Postgres portion already exists — `deploy/backup/smb-db-backup.sh` (`pg_dump` + gzip, 14-day retention, cron on the homelab). Remaining scope for this issue: **n8n** data + **Gitea** (repos + `gitea-db-1` dump) coverage, an **offsite** copy, and a **documented + tested restore**.
mivanchenko added the needs-triage label 2026-07-23 10:31:46 +02:00
mivanchenko added the enhancement label 2026-07-23 10:48:02 +02:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
booking
Booking / Easy!Appointments
 bug
Something is broken
 crm
Back office / CRM
 enhancement
New feature or request
 infra
Infrastructure
 n8n
n8n workflows
 needs-info
Waiting on reporter for more information
 needs-triage
Maintainer needs to evaluate this issue
 ops
Operational / runtime
 ready-for-agent
Fully specified, ready for an AFK agent
 ready-for-human
Requires human implementation
 security
Security / secrets hardening
 tech-debt
Refactor / debt
 wontfix
Will not be actioned
No Label enhancement infra needs-triage ops
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
Administrator mivanchenko
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: BPPP/smb-online#4
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?