this post was submitted on 19 Jun 2023
5 points (100.0% liked)

Lemmy Support

4633 readers
2 users here now

Support / questions about Lemmy.

Matrix Space: #lemmy-space

founded 5 years ago
MODERATORS
 

I've set registration to Require application again, don't like this bots creating accounts.

Also I'm running into email limitations. Using the Sendgrid Free plan of 100 emails per day, but if a couple of member have email notification on, I'm reaching that 100 very quickly. How do others handle the high email traffic ?

you are viewing a single comment's thread
view the rest of the comments
[–] thatcasualgamingguy@lemmy.nerdcore.social 1 points 1 year ago (1 children)

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 was 9 and then used delete 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 the local_user table.

[–] majorswitcher@lemmyfly.org 1 points 1 year ago

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