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

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

from lemmy-docs.

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

from lemmy-docs.

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

from lemmy-docs.

@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.

from lemmy-docs.

had trouble finding this since it was already closed

almost updated my postgres version oh no

thank you for the workaround!

from lemmy-docs.

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

from lemmy-docs.

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

from lemmy-docs.

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

from lemmy-docs.