for only 200 users, you are adding a lot of complexity with an SQL database and no real benefits.
my suggestion for small systems, is to use dovecot with the Maildir format, and to separate domains/virtual hosts as separate system users, thus email accounts are stored as (for example the email i...@domain.com) : /home/domain/mail/domain.com/mail/info email accounts can be stored as simple passwd files under : /home/domain/etc/domain.com/passwd a system like that can easily handle thousands of email accounts. An extra benefit, is that each domain is isolated and separated from other account domains, which is something supported by SELinux on enterprise linux distros (Alma, Rocky, Oracle, etc). no need for an SQL database. On Mon, 13 Mar 2023 13:42:42 +0100 Antonino Di Mauro via Postfix-users <postfix-users@postfix.org> wrote: > about 200 users... > > > Il 13/03/23 13:33, mailmary--- via Postfix-users ha scritto: > > out of curiosity, why do you want to use an SQL database? Do you have more > > than 1,000,000 email accounts? > > > > I don't really see any benefit by using SQL for small to medium sized > > systems. > > _______________________________________________ Postfix-users mailing list -- postfix-users@postfix.org To unsubscribe send an email to postfix-users-le...@postfix.org