Hi in http://www.postfix.org/MYSQL_README.html
we've included the ability to have Postfix reference multiple hosts for access to a single mysql map. This will work if sites set up mirrored mysql databases on two or more hosts. Whenever queries fail with an error at one host, the rest of the hosts will be tried in random order. If no mysql server hosts are reachable, then mail will be deferred until at least one of those hosts is reachable. i have i.e relay_recipient_maps = mysql:/etc/postfix/relay_recipients_mysql.cf user = password = hosts = 1 dbname = postfix query = SELECT address FROM alias WHERE address like '%u\@%d' AND active = 1 so how use fallback on second host simple like this ? relay_recipient_maps = mysql:/etc/postfix/relay_recipients_mysql.cf, mysql:/etc/postfix/relay_recipients_mysql_2.cf with mysql:/etc/postfix/relay_recipients_mysql_2.cf user = password = hosts = 2 dbname = postfix query = SELECT address FROM alias WHERE address like '%u\@%d' AND active = 1 ? -- Best Regards MfG Robert Schetterer Germany/Munich/Bavaria
