... aaand another 136 today

I've just used postgres to export a list of unapproved users with signup IPs into a .csv to add to my firewall blacklist:

copy (select id, sign_up_ip, email, approved from users where approved = 'f') to '/tmp/pendingusers.csv' with CSV DELIMITER ',' HEADER;

I'm not sure how effective it will be, as IP addresses are from all over the place, none are duplicates, but never mind, it's worth a try. 😡