Thanks, I've never heard about that project, imap was cyrus, courier or dovecot for me (I run the latter). The dovecot developers claimed in various mailing list threads, that a SQL based backend would not make sense, not even performance wise. Interesting to see a different approach.

What irks me is the FAQ entry claiming "If you have trouble with user authentication, edit the pg_hba.conf to allow trust or md5"... I - don't think that this is a good idea?

I wrote that sentence.

Trust is not a good idea, in my opinion. But I know that some people disagree with me, and I have better things to do than discuss the issue with them.

MD5 is fine, I think. If you allow randoms from the entire internet to connect, allowing MD5 won't hurt you much more. If you restrict connections to e.g. your own IP addresses using a packet filter or firewall, MD5 definitely will not hurt you.

I've never had to do that before. That would require a very poorly configured Postgres server.

Yes, it would require that. Such servers do exist, I'm sorry to say.

How could I've missed this project? Looks like a nice alternative to http://www.dbmail.org/ .

Yes, here is a technical comparison.

http://archiveopteryx.org/faq/mailstore#dbmail

Yeah, just want to say I heard about MailDB (I posted up another thread), but this sounds very interesting. I will definitely check it out.

Just curious, does anyone run Archiveopteryx in production at scale? Like at the scale that you start using Cyrus Murder with Cyrus IMAP?