this post was submitted on 20 Aug 2023
15 points (94.1% liked)

Lemmy Support

4651 readers
4 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
dessalines@lemmy.ml
15
How to connect to the database if Lemmy is in a docker container? (lemmy.ml)
submitted 1 year ago by utopify_org@lemmy.ml to c/lemmy_support@lemmy.ml
18 comments fedilink hide all child comments
 

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.

you are viewing a single comment's thread
view the rest of the comments
[โ€“] utopify_org@lemmy.ml 1 points 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.