PostgreSQL Version

[lagset]

Hi,
first of all: interesting very polished looking project, I am considering it hosting it privately and giving it a try :)

Question: The docker-compose.yml files in the repos use image: postgres:15-alpine. Is there a reason for it or is it safe to use the current postgres version (image) 18?

Thanks for any response.
cheers
Valentin

[sueun-dev]

hey, I tested the DB/migration path on a fresh 18 DB and it works.

The repo still pins postgres:15-alpine in compose/prod/k8s/CI, but the backend is just SQLAlchemy + asyncpg through DATABASE_URL. I ran the Alembic migrations against a fresh postgres:18-alpine DB and upgrade head completed cleanly. Running it a second time was a no-op at the same head.

The catch is existing data. Do not reuse the same postgres_data volume from 15 after changing the tag. I tested that too and 18 refused the 15-initialized data dir. So for a new private install, 18 looks fine to try. For an existing install, do dump/restore or pg_upgrade, not just an image-tag swap.

[lagset]

thanks for the quick response!