recipe-maintainers/mattermost-lts
0
0
Fork 0
Code Issues Pull Requests 2 Actions Packages Projects Releases Wiki Activity

fix(backup): reimport the postgres dump on restore (restore was a no-op) #1

Open
autonomic-bot wants to merge 1 commits from ci/pg-restore into main
pull from: ci/pg-restore
merge into: :main
Conversation 3 Commits 1 Files Changed 3
+44 -3
autonomic-bot commented 2026-05-30 00:38:54 +00:00
Owner
Copy Link
Copy Source

The recipe dumped the DB on backup but shipped no backupbot.restore.post-hook, and archived the whole live PGDATA dir — so a restore extracted files under the running postgres without reloading them, silently keeping the un-restored state. A restored backup lost all data since the snapshot. Switches to the coop-cloud /pg_backup.sh convention (as matrix-synapse): backup = pg_dump|gzip; restore = terminate connections, FORCE-drop, recreate, reimport. Caught + validated by the cc-ci recipe CI loop (a seeded marker now survives backup→restore).

The recipe dumped the DB on backup but shipped no `backupbot.restore.post-hook`, and archived the whole live PGDATA dir — so a restore extracted files under the running postgres without reloading them, silently keeping the un-restored state. A restored backup lost all data since the snapshot. Switches to the coop-cloud `/pg_backup.sh` convention (as matrix-synapse): backup = pg_dump|gzip; restore = terminate connections, FORCE-drop, recreate, reimport. Caught + validated by the cc-ci recipe CI loop (a seeded marker now survives backup→restore).
autonomic-bot added 1 commit 2026-05-30 00:38:54 +00:00
fix(backup): reimport the postgres dump on restore (restore was a no-op)
cc-ci/testme cc-ci: success
Details
4ca7f4182d 
The recipe dumped the DB on backup but shipped NO backupbot.restore.post-hook, and
archived the whole live PGDATA dir — so a restore extracted files under the running
postgres without reloading them, silently keeping the un-restored (live) state. A
restored backup therefore lost all data written since the snapshot.

Switch to the coop-cloud /pg_backup.sh convention (as matrix-synapse): backup =
pg_dump|gzip -> backup.sql; restore = terminate connections, FORCE-drop, recreate,
reimport the dump deterministically. Archive just backup.sql, not the whole PGDATA dir.
autonomic-bot commented 2026-06-02 00:07:52 +00:00
Author
Owner
Copy Link
Copy Source

@notplants — flagging this open PR from the cc-ci build for your review. Per the updated mirror workflow we no longer auto-close superseded/unrelated PRs, so it's left open for you to merge or close at your discretion.

@notplants — flagging this open PR from the cc-ci build for your review. Per the updated mirror workflow we no longer auto-close superseded/unrelated PRs, so it's left open for you to merge or close at your discretion.
autonomic-bot commented 2026-06-18 01:24:27 +00:00
Author
Owner
Copy Link
Copy Source

!testme

!testme
autonomic-bot commented 2026-06-18 01:24:58 +00:00
Author
Owner
Copy Link
Copy Source

🌻 cc-ci — mattermost-lts @ 4ca7f418 ✅ passed

cc-ci result card

level

full logs · dashboard

<!-- cc-ci:testme --> 🌻 **cc-ci** — `mattermost-lts` @ `4ca7f418` ✅ **passed** [![cc-ci result card](https://ci.commoninternet.net/runs/901/summary.png)](https://drone.ci.commoninternet.net/recipe-maintainers/cc-ci/901) [![level](https://ci.commoninternet.net/runs/901/badge.svg)](https://drone.ci.commoninternet.net/recipe-maintainers/cc-ci/901) [full logs](https://drone.ci.commoninternet.net/recipe-maintainers/cc-ci/901) · [dashboard](https://ci.commoninternet.net/)
All checks were successful
cc-ci/testme cc-ci: success
Details
You are not authorized to merge this pull request.
This pull request can be merged automatically.
This branch is out-of-date with the base branch
View command line instructions

Checkout

From your project repository, check out a new branch and test the changes.
git fetch -u origin ci/pg-restore:ci/pg-restore
git checkout ci/pg-restore
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
autonomic autonomic-bot kawaiipunk (KawaiiPunk) notplants trav (Trav Fryer)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: recipe-maintainers/mattermost-lts#1