This shows you the differences between two versions of the page.
setup_postfix [2012/07/07 00:45] hitronic old revision restored, spam removal |
setup_postfix [2017/08/11 21:59] (current) |
||
---|---|---|---|
Line 27: | Line 27: | ||
* **dbmail-smtp** uses piped delivery through a short-lived process for local delivery only. A new database connection is created and used for each incoming email, reducing performance as compared to LMTP. Server-side filtering with SMTP delivery can be accomplished using a command-line filtering tool such as [[http://en.wikipedia.org/wiki/Procmail|Procmail]], or with DBMail's optional sieve support. | * **dbmail-smtp** uses piped delivery through a short-lived process for local delivery only. A new database connection is created and used for each incoming email, reducing performance as compared to LMTP. Server-side filtering with SMTP delivery can be accomplished using a command-line filtering tool such as [[http://en.wikipedia.org/wiki/Procmail|Procmail]], or with DBMail's optional sieve support. | ||
- | Postfix interfaces directly with MySQL or PostgreSQL to check for aliases before sending mail to dbmail (pipe or LMTP). This improves performance, especially on high-traffic servers (SPAM!). In the case of the use of dbmail-smtp, this is especially useful, because it saves a process [[http://www.gotlandweb.com/|vacation packages]] starting up and connecting to the database on every message. | + | Postfix interfaces directly with MySQL or PostgreSQL to check for aliases before sending mail to dbmail (pipe or LMTP). This improves performance, especially on high-traffic servers (SPAM!). In the case of the use of dbmail-smtp, this is especially useful, because it saves a process starting up and connecting to the database on every message. |
To use MySQL or PostgreSQL with Postfix, first install the postfix-mysql or postfix-pgsql packages (they're in Debian, probably also in other distros). | To use MySQL or PostgreSQL with Postfix, first install the postfix-mysql or postfix-pgsql packages (they're in Debian, probably also in other distros). | ||
Line 99: | Line 99: | ||
The query MUST return a non-domain value (just use "1") | The query MUST return a non-domain value (just use "1") | ||
if the queried domain exists or a empty set if it doesn't exist. | if the queried domain exists or a empty set if it doesn't exist. | ||
- | Returning domains here will [[http://www.americanhomemoving.com/|moving companies]] break the delivery chain of Posfix! | + | Returning domains here will break the delivery chain of Posfix! |
**Note:** In case you use mail addresses as usernames in DBMail, | **Note:** In case you use mail addresses as usernames in DBMail, |