From 282d2ab3e0fb3a74f32160a231225773001acd14 Mon Sep 17 00:00:00 2001 From: grm Date: Mon, 14 Sep 2026 00:51:19 +0300 Subject: Drop the single-database split and re-baseline the control migrations MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Every deployment has been through the per-blog split, so the code that performed it (split.go, control migrations 00002–00007) is dead weight, and a fresh install replaying six migrations only to drop the tables again was silly. The control chain is now a single 00001_init.sql with the final users and blogs shape, matching the blog chain. Goose ignores versions recorded in the database that no longer exist in the source, but refuses a future migration numbered below the database's highest version. Databases that went through the split therefore need `DELETE FROM goose_db_version WHERE version_id > 1` once; README and AGENTS.md say so. Co-Authored-By: Claude Opus 5 Claude-Session: https://claude.ai/code/session_01Sd8UPWrvyYCLj97JexNw3A --- README.md | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'README.md') diff --git a/README.md b/README.md index fbf7412..6a6f224 100644 --- a/README.md +++ b/README.md @@ -126,7 +126,14 @@ above. A dump taken with an older version of Blogspace is upgraded at the next start (or with `blogspace migrate`). Deleting a user in `/admin/` drops their blog database — take a dump first if -you may want it back. Blog pools are small (4 connections each, closed when +you may want it back. + +Upgrading from a single database (installs older than the per-blog split): run +the release that contains the split once (it moves each blog into its own +database at start-up), then clear the old migration history so later +migrations apply: `docker compose exec db psql -U blogspace -c "DELETE FROM +goose_db_version WHERE version_id > 1"`. Current releases no longer carry the +split code. Blog pools are small (4 connections each, closed when idle); with many blogs busy at once, raise `max_connections` on the `db` service. ## Layout -- cgit v1.2.3