I've been receiving and increasing amount of comment spam on my blog. The problem is "people" selling Viagra, porn, penis enlargement systems, etc. want free advertising and want to increase their ranking in Google's Pagerank algorithm. So, these "people" use programs to automatically submit comments in blog entries. I had added a spam filter, but it didn't fully eliminate the problem. I was receiving 10-20 spams per day some days. So I dealt with the problem by closing comments on old entries. I did this by installing a program called pgadmin3, which allows me to connect to PostGRESQL databases and modify them as one would in Microsoft Access. There is a table, mt_entry, that holds all the entries and has a field, entry_allow_comments, indicating if additional comments are allowed. Using an update statement, I set every entry to have a value of 2 here, meaning closed for comments.