## main.cf
# virtual hosting
virtual_transport = virtual
virtual_alias_maps = proxy:mysql:/etc/postfix/mysql-alias_maps.cf
virtual_mailbox_domains = proxy:mysql:/etc/postfix/mysql-domain_maps.cf
virtual_mailbox_maps = proxy:mysql:/etc/postfix/mysql-mailbox_maps.cf
virtual_mailbox_limit = 51200000
virtual_mailbox_base = /var/spool/mail/virtual
virtual_minimum_uid = 207
virtual_uid_maps = static:207
virtual_gid_maps = static:208
local_recipient_maps = $virtual_mailbox_maps

## mysql-* files

# alias_maps
hosts = localhost
user = postfix
password = *
dbname = postfix
query = SELECT goto FROM alias WHERE address = '%s' AND active = true

# domain_maps
hosts = localhost
user = postfix
password = *
dbname = postfix
query = SELECT domain FROM domain WHERE domain = '%s' AND backupmx = false AND active = true

# mailbox_limits
hosts = localhost
user = postfix
password = *
dbname = postfix
query = SELECT quota FROM mailbox WHERE username = '%s'

# mailbox_maps
hosts = localhost
user = postfix
password = *
dbname = postfix
query = SELECT maildir FROM mailbox WHERE username = '%s' AND active = true

# relay_maps
hosts = localhost
user = postfix
password = *
dbname = postfix
query = SELECT domain FROM domain WHERE domain='%s' AND backupmx='1' AND active='1'