Migrate Nova PostgreSQL workloads to Cosmos #120

New issue

Open

opened 2026-07-29 00:11:56 +01:00 by nimmo · 0 comments

nimmo commented

2026-07-29 00:11:56 +01:00

Owner

Move the required PostgreSQL consumers from Nova's Docker PostgreSQL stack to
Cosmos over Nebula, then retire the Nova stack after validation and a rollback
window.

The full database inventory, live-consumer evidence, extension preflight,
cutover checklist, and rollback procedure are in Trilium:
https://notes.nimmog.uk/#root/oFrCkPmeUpeF/gfucXEji9FL6

Scope decisions: airtrail and mem0 are archive-only; do not restore them to
Cosmos. This removes the need to add pgvector for this migration.

Completion requires every remaining database to be classified as migrate or
archive-only, successful dump/restore and service validation for migrated
consumers, then removal of Nova's published PostgreSQL/Adminer stack after the
rollback window.

Move the required PostgreSQL consumers from Nova's Docker PostgreSQL stack to Cosmos over Nebula, then retire the Nova stack after validation and a rollback window. The full database inventory, live-consumer evidence, extension preflight, cutover checklist, and rollback procedure are in Trilium: https://notes.nimmog.uk/#root/oFrCkPmeUpeF/gfucXEji9FL6 Scope decisions: airtrail and mem0 are archive-only; do not restore them to Cosmos. This removes the need to add pgvector for this migration. Completion requires every remaining database to be classified as migrate or archive-only, successful dump/restore and service validation for migrated consumers, then removal of Nova's published PostgreSQL/Adminer stack after the rollback window.

nimmo added this to the Service Stack NixOS Migration milestone

2026-07-29 00:11:56 +01:00

nimmo added the

project:service-stack-migration

phase:prep

host:fleet

labels

2026-07-29 00:11:56 +01:00