On Sun, Apr 15, 2007 at 12:03:10PM +0200, Joachim Schipper wrote: > > > > That was the primary reason for using postfix with dovecot. Years > > back, I tried to get both sendmail and postfix working with SMTP AUTH > > and Cyrus as I recall. It was a mess. The super-easy integration of > > postfix and dovecot for SMTP AUTH is a welcome change. > > I think the main trick is in writing scripts that generate all databases > from a single main file. This is fairly easy using perl, awk, .... > > Of course, this becomes a hundred times more difficult the moment user > administration is not done centrally. >
At an ISP that I worked for, all user config data was held in postgres. When fields were changed, new flat files were generated (passwd, shell.allow, ftpusers, apache, quota, etc, etc). The files were then scp'd to the various server farms from the postgres box. Having the mail daemons use SQL for auth was too slow. Customers and support staff had web interfaces to postgres for config of services.
