[Dovecot] mail-sql update

[Timo Sirainen]

On Mon, 2007-11-12 at 16:27 +0000, Daniel Watts wrote:
> > SQL backend has been possible for a long time and there's already a
> > kind-of working version available:

Wasted a bit of time getting it to work again. It's horribly inefficient
when saving messages and EXPUNGE seems to be somewhat broken, but at
least it kinda works. :)

http://dovecot.org/patches/mail-sql.patch
http://dovecot.org/patches/mail-sql.tar.gz

Unpack mail-sql.tar.gz to src/plugins/, apply the patch, run autogen.sh
and configure. Use:

mail_location = sql:pgsql:dbname=mails host=localhost user=foo password=bar

(the key=value pairs are named the same as in dovecot-sql.conf)

> Hey that's cool - didn't realise this was available . Timo what is your 
> own opinion of sql based mail storage vs maildir (or dbox)? When is it a 
> good idea?

I don't really know. Maybe if you want to use the mail database for
something special. Performance definitely isn't a reason.

I'm not sure if this would allow multi-master replication though. I know
MySQL offers support for it, but what happens when both masters have
added a row that causes a unique key collision? Can you write triggers
to fix those cases automatically?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20071112/1d6eac49/attachment.bin