dbpath = /etc/postfix/private/mail.sqlite query = SELECT AD.addLocalpart FROM Address AS AD JOIN Domain AS D1 ON AD.addDomNum=D1.domNum WHERE AD.addLocalpart IS '%s' AND D1.domName IS 'myhostname.example.org' AND AD.active!=0; # This is an optional query for local_recipient_maps. I chose not to # deploy it for usability reasons, but this file is here as # demonstration that the one SQLite database can indeed manage all # Postfix lookups. # # This will work as-is with the sample data if the local_recipient_maps # line in main.cf is uncommented. To continue to use it, ensure that any # new local user is added to Addresses, and closed accounts are deleted. # # Note the hardcoded value of $myhostname, as in alias_maps.