I was hoping that I could leave open registration here for a few days, but apparently there are a ton of lemmy bots. I got 18k within 2 days.
So I logged in to my server, and did this:
- Run docker ps to get the name of the container running postgres.
- docker exec -it <container name> /bin/bash
- psql -h localhost -p 5432 -U lemmy -d lemmy
- The bot users in my case were all users where id>=3 in my case.
- So I ran DELETE FROM TABLE local_user where id>=3
- Done
To anyone else with this problem, this approach will only work if the bots are within a certain range of user ids. Still, it worked in my very simple case so I’ll leave it here.
User registration is no longer open. My VPS provider tends to block outbound 485, so until I sort that out, user registration is temporarily closed.
Hi o/ I think my account may have been deleted in the cleanup… same username as this lemmy.ml :)