Use a HASH table before implementing this in SQL. /etc/postfix/main.cf: transport_maps = hash:/etc/postfix/transport ..whatever you already have.../etc/postfix/transport: u...@test.com smtp:[the old machine] # postmap hash:/etc/postfix/transport # postfix reload # postmap -q u...@test.com hash:/etc/postfix/transport smtp:[the old machine] Once you have that working, start playing with SQL. Wietse
Thank you, Wietse, using a hash table worked;