Lemmy from scratch install instructions fail with "thread ‘main’ panicked at ‘Couldn’t run DB Migrations’, crates/db_schema/src/utils.rs:165:25"

[RocketDerp]

As a workaround, before starting the lemmy server:

sudo -iu postgres psql -c “ALTER USER lemmy WITH SUPERUSER;”

It seems that the problematic SQL has been identified in this pull request?

LemmyNet/lemmy@29c4144

[dessalines]

Could you do a PR to add that to the docs?

[sunaurus]

Adding superuser privileges is not an ideal solution - it means that Lemmy won't work on any managed cloud database which prevents superuser access. This PR seems like a better solution: LemmyNet/lemmy#3002

[sunaurus]

FYI as LemmyNet/lemmy#3002 was merged, I believe this issue can be closed

[ffolkes]

This is not working for me, and I'm puzzled why. I confirmed it was added, but I'm still getting the migrations error. When will the patch be available via crates.io? I'm anxious to get my instance up and running. :)

postgres=# \du
lemmy | Superuser

[Nutomic]

That fix is not released yet, it will be in 0.18

[bengtfredh]

@ffolkes I had same issue. Found out database server was missing postgresql extensions ltree and pgcrypto.

[ffolkes]

@ffolkes I had same issue. Found out database server was missing postgresql extensions ltree and pgcrypto.

Thank you! That did it. :) On Rocky 9 I needed to do "dnf install postgresql-contrib" and then "CREATE EXTENSION IF NOT EXISTS pgcrypto;" and "CREATE EXTENSION IF NOT EXISTS ltree;" then grant lemmy superuser to start it until the patch rolls out.

[kartonrad]

had trouble finding this since it was already closed

almost updated my postgres version oh no

thank you for the workaround!