On Thu, 2004-07-15 at 00:13, Ross Gohlke wrote: > from DBMail INSTALL.postfix: > To use MySQL or PostgreSQL with Postfix, first install the postfix-mysql > or postfix-pgsql packages (they're in Debian, probably also in other > distros). > > My setup: > Mac OS 10.2 > Postfix 2.1.4 (from source) > PostgreSQL 7.4.1 (from source) > > I'm not aware of a postfix-pgsql source package. Here's what I did for > Postfix: > Download source, untar postfix-2.1.4 > Download pgsql patch into postfix-2.1.4 <http://mat.cc/postfix/> > patch -p1 < postfix-pg.postfix-2.0.0.2.patch > make makefiles CCARGS='-traditional-cpp -DHAS-PGSQL -DUSE_SASL_AUTH > -DHAS_PCRE -I/Library/Frameworks/SASL2.framework/Headers > -I/usr/local/include/sasl -I/usr/local/pgsql/include' AUXLIBS='-lpq -ldb > -lpcre -lcrypto -lsasl2 -L/usr/local/lib -L/usr/local/lib/sasl2 > -L/usr/local/pgsql/lib -L/usr/lib/sasl2' (this was gleaned from lots of > READMEs and google results) > make > sudo make install > The wonder is, everything actually worked. > Per DBMail INSTALL, I added this to /etc/postfix/main.cf: > local_recipient_maps = pgsql:/etc/postfix/sql-recipients.cf > > Here's my mail.log file: > Jul 14 23:07:47 boomhaus postfix/smtpd[11496]: fatal: unsupported > dictionary type: pgsql > Jul 14 23:07:48 boomhaus postfix/master[9889]: warning: process > /usr/libexec/postfix/smtpd pid 11496 exit status 1 > Jul 14 23:07:48 boomhaus postfix/master[9889]: warning: > /usr/libexec/postfix/smtpd: bad command startup -- throttling > > Not only did postfix's original PGSQL README not mention anything about > the patch (leading me to believe it may no longer be necessary), the > patch seems pretty outdated. I tried several different compile options > without the patch first. > > QUESTION #1 > How important is having pgsql support compiled into postfix, from a > DBMail perspective? > > QUESTION #2 > Any ideas what I'm doing wrong? > > Thanks, > ross > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
Well to me is important because I have postfix to authenticate users to my PostgreSQL database BTW I'm runnin Debian Woody + PostgreSQL 7.4.3 -- ,''`. Leonel Nunez : :' : http://enelserver.com `. `' DEBIAN GNU/LINUX `- A REAL FREE OS
