Devdas, that worked! Sorta. At least now it reveals another message: postmap: warning: connect to pgsql server localhost: FATAL: Ident authentication failed for user "dbmail"?
but I can psql into the db just fine with those settings. Got it. had to s/localhost/127.0.0.1/ for everything. I have yet to find out why, but sqlgrey & amavis had the same issue. pg_hba.conf remained the same though. muchas gracias ----- Original Message ---- From: Devdas Bhagat <[email protected]> To: [email protected] Sent: Thu, December 10, 2009 8:51:08 AM Subject: Re: up'd Fedora from 10->11, now postmap won't query pgsql db On Thu, Dec 10, 2009 at 05:42:13AM -0800, Brian Neu wrote: > After updating postfix & postgresql (still 8.3 though), postmap lookups > to postgres aren't working anymore. I HAVE recompiled postfix rpm to > include the postgresql libraries. > <snip> > > I get: > > ]# postmap -q [email protected] pgsql:pgsql-v-alias-maps.cf > postmap: fatal: bad string length 0 < 1: pgsql-v-alias-maps.cf_dbname = > Use the full path to the map. Relative paths end up looking for the map_name_variable inside main.cf for historical reasons. Devdas Bhagat
