this post was submitted on 03 Nov 2025
53 points (96.5% liked)
Fediverse
37666 readers
67 users here now
A community to talk about the Fediverse and all it's related services using ActivityPub (Mastodon, Lemmy, KBin, etc).
If you wanted to get help with moderating your own community then head over to !moderators@lemmy.world!
Rules
- Posts must be on topic.
- Be respectful of others.
- Cite the sources used for graphs and other statistics.
- Follow the general Lemmy.world rules.
Learn more at these websites: Join The Fediverse Wiki, Fediverse.info, Wikipedia Page, The Federation Info (Stats), FediDB (Stats), Sub Rehab (Reddit Migration)
founded 2 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Are you using postgresql 18? I tried upgrading yesterday from 17.6 and got an identical error message.
Indeed, Postgres 18 introduced some breaking changes and AFAIK Lemmy isn't compatible with them yet. This will probably be fixed in the next release.
That'd be a relief if that's the case.
I've been getting a bit demoralized trying to figure this out.
Yes, it looks like the supplied docker-compose.yml points to
pgautoupgrade/pgautoupgrade:18-alpinefor the postgres image.try this
But, make a backup of your db beforehand. I don't know how it would work when upgrading an existing database