I’ve installed Lemmy via ansible, but I figured out that there are problems with emails and after I’ve created a user, no verification email came, no login is possible and now I have a ghost account I want to delete.

Because I couldn’t find an UI element to purge users in the admin panel, I want to do it over postgresql, but I have no idea how to connect to the Lemmy database over a docker container, only thing I’ve found is to backup/restore the whole database:

docker-compose exec postgres pg_dumpall -c -U lemmy | gzip > lemmy_dump_date +%Y-%m-%d""%H%M_%S.sql.gz

Thank you for your help.

  • maxmoonOP
    link
    fedilink
    English
    arrow-up
    2
    ·
    edit-2
    1 year ago

    I found a solution here

    A warning to people who have the same problem:

    On the website there is a command, which will purge all unverified account. If your admin account wasn’t verified, it will be purged, too.

    Thanks a lot for your help :)

    • ikornaselur@lemm.ee
      link
      fedilink
      arrow-up
      1
      ·
      1 year ago

      Glad you solved it! Definitely sounds like a better solution than playing around in the db

      • maxmoonOP
        link
        fedilink
        English
        arrow-up
        1
        ·
        1 year ago

        Well, it is playing around with the db 😀 … and it could even destroy the whole instance if people don’t see the warning I’ve posted there.