On Dienstag 23 Juni 2009 James Greig wrote:
> I Have to agree with Paul on this one - You're much better off doing
> this at the postfix level.  Infact, we have a separate table within
> dbmail called dbmail_redirect which holds maps/forwarders it's
> unnecessary additional work for dbmail long term anyway.

Thanks Greg, I created a table zmi_rewritedomains with simply "oldname", 
"newname" and changed

recipient_canonical_maps = pgsql:/etc/postfix/rewritedomains.sql, 
pgsql:/etc/postfix/recipients-rewrite.sql

so that rewritedomains.sql looks like:
query = SELECT '%u@' || newname FROM zmi_rewritedomains WHERE oldname = 
'%d'

Quite simple, but I wanted to prevent a schema extension just for this.

mfg zmi
-- 
// Michael Monnerie, Ing.BSc    -----      http://it-management.at
// Tel: 0660 / 415 65 31                      .network.your.ideas.
// PGP Key:         "curl -s http://zmi.at/zmi.asc | gpg --import"
// Fingerprint: AC19 F9D5 36ED CD8A EF38  500E CE14 91F7 1C12 09B4
// Keyserver: wwwkeys.eu.pgp.net                  Key-ID: 1C1209B4

Attachment: signature.asc
Description: This is a digitally signed message part.

_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev

Reply via email to