this post was submitted on 18 Jul 2023
64 points (95.7% liked)
Lemmy
12535 readers
27 users here now
Everything about Lemmy; bugs, gripes, praises, and advocacy.
For discussion about the lemmy.ml instance, go to !meta@lemmy.ml.
founded 4 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
You should be able to purge the user if you visit their profile.
And How would I do that in the UI? This is the issue, haven't found a way to even find those users on my system, even though it marks at 15 extra users.
Did you find a solution. The above comment with the database query should work. You can access the docker container where the database is running with
docker exec -it instancedomain_postgres_1 busybox /bin/sh
and then runpsql -U databaseuser
which by default is 'lemmy'.Check
docker ps
to know the exact name of the postgres container which in your case likely is lemmytalungorg_postgres_1Thanks, I have gone through and identified the REAL accounts gathered the ID's and deleted the rest from local_user and person tables.
Haven't really played much with Postgress so took some time to look up all the functionality with that.
EDIT: yup, made sure the person one was local only :)