this post was submitted on 19 Jun 2023
33 points (100.0% liked)
Lemmy Support
4662 readers
22 users here now
Support / questions about Lemmy.
founded 5 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
Just did that for my instance. Luckily it's fairly easy. Since there were no human registrations after those bots I just looked up the lowest bot id in the
local_user
table which was9
and then useddelete from person where id in (select person_id from local_user where id >= 9);
. Thanks to the references and triggers on the table, the rest of the database was also cleaned up by that, including thelocal_user
table.For me it were the last 30 or something entries in local_user. They all didn’t have email_verified. I access the db through Postico. Also removed all other older accounts that didn’t verify their email address