trivial-rewrite and postgres setup

2010-11-05 Thread Matthias Leopold

hi,

i'm using postfix 2.5.5 with a postgres backend setup. everything works 
fine (as far as i can see) but looking at my logfiles i'm wondering why 
the domain part of sender addresses is being looked up in my 
virtual_mailbox_domains table.


i'm seeing lines like these in my logfiles:

postfix/trivial-rewrite[12345]: warning: table 
pgsql:/etc/postfix/virtual_mailbox_domains: empty lookup result for: 
senderdomain.com -- ignored


is this related to address verification or is it an indication of 
misconfiguration? as is said everything works fine but i think these 
lookups might cause performance problems when the server gets busy.


i'm willing to post configuration details, i just wanted to ask the 
basic question first.


thx for advice
matthias



Re: trivial-rewrite and postgres setup

2010-11-05 Thread Wietse Venema
Matthias Leopold:
 hi,
 
 i'm using postfix 2.5.5 with a postgres backend setup. everything works 
 fine (as far as i can see) but looking at my logfiles i'm wondering why 
 the domain part of sender addresses is being looked up in my 
 virtual_mailbox_domains table.
 
 i'm seeing lines like these in my logfiles:
 
 postfix/trivial-rewrite[12345]: warning: table 
 pgsql:/etc/postfix/virtual_mailbox_domains: empty lookup result for: 
 senderdomain.com -- ignored

Lookup tables (SQL or otherwise) should return NOT FOUND instead
of returning zero-length result.

Wietse