Source

iredmail / iRedMail / samples / postfix / pgsql / transport_maps_user.cf

Full commit
1
2
3
4
5
6
user        = vmail
password    = yCrSkh8YsoGn6GNKSVCVomi6ecb4Pi
hosts       = 127.0.0.1
port        = 5432
dbname      = vmail
query       = SELECT mailbox.transport FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.domain='%d' AND mailbox.domain=domain.domain AND mailbox.transport<>'' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.backupmx=0 AND domain.active=1