Postfix
-------

- Pause Mail Delivery:
	postconf -e defer_transports=smtp; service postfix reload

- Resume mail delivery:
	postconf -e defer_transports=; service postfix reload

- List the messages in the mail queue:
	postqueue -p
  
- Delete a message in the mail queue:
	postsuper -d "Queue ID from previous command"

- Informació d'un missatge en cua:
	postcat -vq XXXXXXXXXX
	postcat -qe XXXXXXXXXX
	postcat -qh XXXXXXXXXX
			-> Message-ID: <...>
SQL:
---
/etc/postfix/main.cf:
	sender_bcc_maps = mysql:/etc/postfix/mysql-virtual-bcc-maps.cf

/etc/postfix/mysql-virtual-bcc-maps.cf
	user = (database user)
	password = (database password)
	hosts = 127.0.0.1
	dbname = (database databasename)
	query = SELECT CONCAT_WS('',LEFT('%s', LOCATE('@', '%s')-1),'+sent@',SUBSTRING('%s', LOCATE('@', '%s')+1)) AS destination FROM virtual_users WHERE email='%s' AND autosent=1




/etc/postfix/mysql-virtual-mailbox-domains.cf
	user = mailuser
	password = fLxsWdf5ABLqwhZr​    <- use your own database password here
	hosts = 127.0.0.1
	dbname = mailserver
	query = SELECT 1 FROM virtual_domains WHERE name='%s'

postconf virtual_mailbox_domains=mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf


The test data you created earlier added the domain “example.org” as one of your mailbox domains. Let’s ask Postfix if it recognizes that domain:
postmap -q example.org mysql:/etc/postfix/mysql-virtual-mailbox-domains.cf