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

[Patrick Domack]

For my personal email, I have a habit of having the sql server down  
for one reason or another. I just dump the sql tables to flatfiles on  
the email server, and a script runs every 15min and checks for updates  
if any exist. Works well.

Another method would be to just keep it sql, but dump the mysql tables  
into sqlite tables that postfix/dovecot use.


Quoting Voytek <voytek at sbt.net.au>:

> On Wed, September 28, 2011 6:47 am, Nick Rosier wrote:
>
>> My main concern was losing mails if the DB is unavailable but this isn't
>> a problem; if the DB is unavailable Postfix will return a temporarily
>> unavailable and the MTA should retry.
>
> yes, that was also my biggest concern when I 1st looked at the issue,
> after several years of usage, it still remain my biggest concern
>
> luckily, it's just a concern, never caused a problem, and, mail will queue
> up if there are issues