On 2017-05-30 08:30, Per Jessen wrote:
David C. Rankin wrote:
On 05/29/2017 11:46 AM, Anton Aylward wrote:
Postfix doesn't *NEED* MySQL to do this. it can do it entirely with regular files.
Have use postfix for 17 years (both on a home server and office server supporting 5 law firms and one engineering firm) and never used anything but the default postfix backend. No mysql no database no nothing. There was never a bit of slowdown due to a lack of database backend.
I completely concur, unless you are handling thousands of user accounts, then all the db backend does is add another unnecessary layer of complexity to be maintained. If you are an ISP or fortune 500 company and are saturating your server load, then yes, there are indexing benefits from a database, if not, there is no benefit.
For less than 20 users on a single domain, I wouldn't bother with mysql either, but it's not a performance question, it's only about management and maintenance. Once you've got it running with mysql, you won't want to go back.
In fact, the text files have to be converted to binary, as this: postmap transport I have a Makefile to do the conversion of the needed files, makes life easier. Click with 'mc' on it, done. I also use 'mc' to edit postfix configuration. -- Cheers / Saludos, Carlos E. R. (from 42.2 x86_64 "Malachite" (Minas Tirith))