Le 25/09/2010 20:09, Toni Mueller a écrit :
[snip]
thanks for the hints. I've tried again. Now I can see that:
email=# select * from transport_map where email ilike '%bugs%';
id | email | transport
----+------------------+-----------
11 | r...@bugs.oeko.net | local:
10 | bugs.oeko.net | local:
(2 rows)
# postmap -q rt-comm...@bugs.oeko.net pgsql:/etc/postfix/transport_maps
# postmap -q r...@bugs.oeko.net pgsql:/etc/postfix/transport_maps
local:
#
I have trouble reconciling this with the pattern matching section in
transport(5). In PostgreSQL's log, I see only this query:
SELECT transport from transport_map where email = 'rt-comm...@bugs.oeko.net'
Do I need to specifically enable pattern matching somehow?
No, you don't need to.
postmap only does one query. postfix does many. See "TABLE SEARCH ORDER" in
http://www.postfix.org/transport.5.html
test the result of
# postmap -q bugs.oeko.net pgsql:/etc/postfix/transport_maps
On a side note, can I specify some kind of query results caching?
None shows in
http://www.postfix.org/pgsql_table.5.html
proxymap allows "To consolidate the number of open lookup tables by
sharing one open table among multiple processes":
http://www.postfix.org/proxymap.8.html
