Skip Navigation
InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)LS
Lemmy Support @lemmy.ml
lemmy_newbie @lemmy.ml

DB Migration Errors - Installing from scratch (manual)

Hi all,

I'm trying to install Lemmy on a FreeBSD server. The build went fine but when I run it, I get errors saying that the migrations failed, however it seems like all databases were created.

I also am not that Rust savvy so maybe there is another way to get more debug output.

You can see the logs and sql tables here:

https://paste.sr.ht/~petersanchez/b9962c7b13d2aeba1c3c656f6f046230c4daf059

Any ideas?

Thanks!

You're viewing a single thread.

1 comments

  • The lemmy user in the database needs superuser privilages. Add superuser to the lemmy account, drop the database, and then recreate it. 

     
        
sudo -iu postgres psql -c "ALTER USER lemmy WITH SUPERUSER;"
sudo -iu postgres psql -c "DROP DATABASE lemmy;"
sudo -iu postgres psql -c "CREATE DATABASE lemmy WITH OWNER lemmy;"

    Edit: they may have fixed this but I'm not sure what version it's in. Let me know if that doesn't work. https://github.com/LemmyNet/lemmy/pull/3002