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 | [email protected] | local:
10 | bugs.oeko.net | local:
(2 rows)
# postmap -q [email protected] pgsql:/etc/postfix/transport_maps
# postmap -q [email protected] 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 = '[email protected]'
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
