Postfix/Notes_on_converting_a_customer_to_virtual_mailboxes

From work, notes made for an enquiry regarding wave50

postfixadmin

postfixadsmin requires virtual mailboxes
means migrating to virtual mailboxes
virtual mailboxes are centrally owned
need to restructure into /domain/user
virtual mailboxes means virtual delivery
could maybe stay as mbox, will still need to point to other "folders"
need to normalise all addresses (will take a few hours at least)

postfix lookups

postfix needs to back onto the DB
can shape the queries a little bit, but not that much
don't have to use Deliver, but it's good

dovecot

dovecot has to use the DB for mail location now
dovecot shares that DB for auth now
this affects SASL
everyone's SASL credentials may have to change

implementation thoughts

convert to LDA (postfix -> dovecot -> LDA delivery)
this would shift out of system users
need to normalise all addresses first
difference between passwd file and SQL should be pretty small
could use imapsync to move all the mail?

time estimates

address normalisation - 3hrs
mbox to maildir conversion - 3hrs (some 540MiB of mail)
planning time so far - 2hrs
documentation - 2hrs
setup postfixadmin - 0.75hrs
populate the DB backend - 2hrs
configure postfix - 0.75hrs
configure dovecot - 1hrs
testing - 2hrs
pricing - 0.5hrs