Postgres 14 nearing EOL — upgrade to a newer LTS version

[DaanSelen]

Summary

sentry/self-hosted currently deploys postgres:14.23-bookworm. PostgreSQL 14 reaches end-of-life in September 2026 (~2 months from now). The project should adopt a newer LTS version before support ends.

Findings

• docker-compose.yml:166 pins the image to postgres:14.23-bookworm and explicitly notes it is kept in sync with the Sentry dev environment.
• install/upgrade-postgres.sh only covers the 9.6 → 14 migration path; a newer major version would require a new migration plan.
• Dependabot PR build(deps): bump postgres from 14.23-bookworm to 18.4-bookworm #4413 previously attempted to bump to 18.4-bookworm but was closed without merging.

Related

• build(deps): bump postgres from 14.23-bookworm to 18.4-bookworm #4413

[sentry-pierre]

I cleaned this up and added the exact repository context so the request doesn’t have to compete with the template noise.

What I checked:

• docker-compose.yml is on postgres:14.23-bookworm and tracks the Sentry dev version.
• install/upgrade-postgres.sh only handles 9.6 → 14.
• Dependabot PR build(deps): bump postgres from 14.23-bookworm to 18.4-bookworm #4413 already attempted the bump and was closed.

A maintainer will need to coordinate the upgrade with Sentry dev and update the migration tooling.

[aldy505]

We follow version running on SaaS, and they're currently migrating to Postgres 17, we'll follow suit as well.

[DaanSelen]

We follow version running on SaaS, and they're currently migrating to Postgres 17, we'll follow suit as well.

Any ETA on that?