How do you truncate the Greylist SQLite database on a mail server?

[eugenevdm]

Our mail server's performance has deteriorated very heavily in the last two weeks. I've turned off every single bit of spam protection except Greylisting and it's still slow. Upon delving in the greylisting folder I notice the greylisting data is 2.5GB big.

root@cm:/var/lib/plesk/mail/greylist# ls -lah
total 2.5G
drwxr-xr-x 2 root root 4.0K 2012-03-17 16:40 .
drwxr-xr-x 5 root root 4.0K 2009-12-03 07:36 ..
-rw-r--r-- 1 root root 2.5G 2012-03-17 16:40 data.db
-rw-r--r-- 1 root root 76K 2012-03-16 13:53 settings.db

Could this be a problem? How do you truncate it? I don't mind starting from scratch because it's would be better than multiple phone calls from some of the 12 000 mail users on the server.

 

[burnleyvic]

cp -p /var/lib/plesk/mail/greylist/data.db /var/lib/plesk/mail/greylist/data.db.backup
sqlite3 /var/lib/plesk/mail/greylist/data.db
sqlite> delete from data;

Check 'man sqlite3'

 

[eugenevdm]

Thanks a lot. I like the "-p". Incidentally our mail server is still performing poorly. I guess there are just too many e-mail accounts on it and Plesk / Postfix is the wrong platform for high volumes.