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.
Try to get a bash prompt inside the dB container, then you can run CLI postgres commands from inside the container.
How exactly? The recommendations of other people here didn’t work.
EDIT: Found a solution. Check other posts to see how it works.