Source

iredmail / iRedMail / samples / postfix / pgsql / domain_alias_catchall_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 alias.goto FROM alias,alias_domain,domain WHERE alias_domain.alias_domain='%d' AND alias.address=alias_domain.target_domain AND alias_domain.target_domain=domain.domain AND alias.active=1 AND alias_domain.active=1