Source

iredmail / iRedMail / samples / postfix / pgsql / virtual_mailbox_maps.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.storagenode || '/' || mailbox.maildir || '/Maildir/') FROM mailbox,domain WHERE mailbox.username='%s' AND mailbox.active=1 AND mailbox.enabledeliver=1 AND domain.domain = mailbox.domain AND domain.active=1