On 25/10/24 22:28, Viktor Dukhovni via Postfix-users wrote:
That will work poorly with SSL. The reason to have a Postgres database, as opposed to something simple like "cdb" tables, is to share data across multiple hosts, so I'm sceptical that "127.0.0.1" is the norm for using Postfix with a Postgres table backend. If you just have a single machine, a Postgres backend is rather overkill.
Here I have to disagree. Another good reason to use an SQL backend is to share data across multiple services on the *same* host, (e.g. postfix, dovecot, roundcube). An argument could be made here for using sqlite instead but I don't think it's unreasonable in this case to use PostgreSQL. Also SQL dbs can be easier to update from admin control panels and such making it easier to design and implement such features around an SQL backend that all of the various components can access. This could all be done on the same host.
I don't know if this makes 127.0.0.1 "the norm" but it is far from an unusual configuration.
Peter _______________________________________________ Postfix-users mailing list -- postfix-users@postfix.org To unsubscribe send an email to postfix-users-le...@postfix.org
