[Dovecot] What best decision to make for flatfiles or SQL when I use Dovecot2 + Postfix together?

[Patrick Domack]

Well, the info dovecot needs, it mailbox name/location, username,  
password, and quota, misc info.

postfix will need email address to mailbox name mapping info.

That is the very basic things you need.

Using dovecot lda/lmtp you remove all postfix needs to know mailbox  
name to directory mapping, that would be duplicated.


Quoting terryjames9461 at mm.st:

> Hello Tom,
>
> On Tuesday, September 27, 2011 7:29 PM, "Tom Hendrikx"
> <tom at whyscream.net> wrote:
>> The problem with passwd(like) files is that they are almost never in the
>> correct format to fit both daemons. The easiest way to use a database.
>
> I don't yet see using a database easier than flatfiles.  I understand
> that the one-instance data is done well in a database.
>
> But also I found this page at the Dovecot wiki,
> http://wiki2.dovecot.org/HowTo/VirtualUserFlatFilesPostfix.  I keep
> rereading it and I think that it tells me that I can do this with
> flatfiles only.
>
> I think its this section,
> http://wiki2.dovecot.org/HowTo/VirtualUserFlatFilesPostfix#Master_Configuration,
> that tells how to share data with Postfix.  Except there's also LMTP
> which I haven't figured out how to do it yet.
>
> For only 3 domains and 30 users its silly to have to run a mysql
> database.  But who knows yet if I an reading this right, and if sharing
> flatfiles are possible?  Its confusing to read and understand.
>
> TJ