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