You should already have installed Postfix (with support for PostgreSQL maps and Dovecot SASL), Dovecot (with PostgreSQL support), PostgreSQL, Python + pyPgSQL and optionally pycrypto if you want to store the passwords as PLAIN-MD4 digest.
Contents
Check for pgsql support in Dovecot and Postfix
To verify that your Dovecot and Postfix installation has support for PostgreSQL use the postconf and dovecot commands as shown in the example below.
hostname ~ # postconf -m | grep pgsql pgsql hostname ~ # postconf -a | grep dovecot dovecot hostname ~ # dovecot --build-options | grep postgresql SQL drivers: mysql postgresql sqlite hostname ~ #
If your Dovecot and/or Postfix installation shouldn't support PostgreSQL you could possibly fix this by installing the missing package (see below) or by recompiling the corresponding part.
Package names by OS/Distribution
Compiling from Sources
- coming soon…
Debian GNU/Linux (Etch/Lenny/Squeeze)
postfix and postfix-pgsql
dovecot-common, dovecot-imapd and/or dovecot-pop3d
postgresql-client (or postgresql, if you do not have a PostgreSQL server.)
python, python-egenix-mxdatetime and python-pgsql optionally python-crypto
Optionally gettext
FreeBSD
Packages or build from ports:
- dovecot
- postfix
- postgresql-client (and postgresql-server, if you do not have a PostgreSQL server.)
- python25, py25-mx-base and py25-pyPgSQL optionally py25-pycrypto
Gentoo Linux
Applied use-Flags (/etc/portage/package.use):
mail-mta/postfix dovecot-sasl postgres -pam sasl net-mail/dovecot postgres -pam pop3d sieve dev-db/postgresql-server -perl
OpenBSD
Packages or build from ports:
- postfix
- dovecot
- postgresql-client
- python and py-mxDateTime optionally py-crypto
Build from source:
openSUSE Linux (10.3/11.0) (SLES?)
- postfix and postfix-postgresql
- postgresql-server and postgresql
- dovecot
- python and pyPgSQL optionally python-crypto
RHEL/CentOS/Fedora
- coming later (needs some tests or provide your information)