55
Could anyone help me set up a lemmy instance?
(ttrpg.network)
A community to talk about the Fediverse and all it's related services using ActivityPub (Mastodon, Lemmy, Mbin, etc).
If you wanted to get help with moderating your own community then head over to !moderators@lemmy.world!
Learn more at these websites: Join The Fediverse Wiki, Fediverse.info, Wikipedia Page, The Federation Info (Stats), FediDB (Stats), Sub Rehab (Reddit Migration)
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