jared/server-ovh-prod-01-main
Archived
Watch
1
0
Fork
You've already forked server-ovh-prod-01-main
 0
Code Issues 5 Pull requests Projects Releases Packages Wiki Activity

Evaluate Postgres major-version upgrade path (n8n x2, remetrics) #8

Open
opened 2026-08-12 16:45:51 +00:00 by jared · 1 comment
jared commented 2026-08-12 16:45:51 +00:00
Owner
Copy link

Context

2026-08-12 fleet image review (ticket #5, first occurrence) found Postgres containers running on old major versions with no automated path forward (Watchtower does not manage DB majors):

  • n8n-postgres-1 (n8n stack): postgres:16
  • n8n-test-postgres-1 (n8n-test stack): postgres:16
  • remetrics-db-1 (remetrics stack): postgres:15

Current latest major on Docker Hub is postgres:18. These are 2-3 majors behind. Major-version Postgres upgrades require pg_upgrade or dump/restore, not a simple image swap, so this needs a planned migration rather than a routine patch bump.

Suggested steps

  1. Confirm whether each app (n8n, remetrics) supports the target major.
  2. Plan per-stack: pg_dumpall backup, upgrade via pg_upgrade or dump/restore, verify data integrity, rollback plan.
  3. Schedule a maintenance window per stack (these are production services).
## Context 2026-08-12 fleet image review (ticket #5, first occurrence) found Postgres containers running on old major versions with no automated path forward (Watchtower does not manage DB majors): - n8n-postgres-1 (n8n stack): postgres:16 - n8n-test-postgres-1 (n8n-test stack): postgres:16 - remetrics-db-1 (remetrics stack): postgres:15 Current latest major on Docker Hub is postgres:18. These are 2-3 majors behind. Major-version Postgres upgrades require pg_upgrade or dump/restore, not a simple image swap, so this needs a planned migration rather than a routine patch bump. ## Suggested steps 1. Confirm whether each app (n8n, remetrics) supports the target major. 2. Plan per-stack: pg_dumpall backup, upgrade via pg_upgrade or dump/restore, verify data integrity, rollback plan. 3. Schedule a maintenance window per stack (these are production services).
jared commented 2026-08-12 20:16:49 +00:00
Author
Owner
Copy link

Migrated to jared/servers#12

Migrated to jared/servers#12
Commenting is not possible because the repository is archived.
No Branch/Tag specified
Branches Tags
main
No results found.
Labels
Clear labels   
P0

   
P1

   
P2

   
P3

   
next

   
ready-for-agent

   
ready-for-human

   
recurring

   
review

   
waiting
No labels
P0
P1
P2
P3
next
ready-for-agent
ready-for-human
recurring
review
waiting
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
No assignees
1 participant
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set

Reference
jared/server-ovh-prod-01-main#8
No description provided.