Installation Prerequisites

You already should have installed and configured Postfix and Dovecot ≥ 2.0.0 with PostgreSQL support. You also need access to a local or remote PostgreSQL server.

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 below:

root@host:~# postconf -m | grep pgsql
pgsql
root@host:~# postconf -a | grep dovecot
dovecot
root@host:~# dovecot --build-options | grep postgresql
SQL drivers: mysql postgresql sqlite

vmm depends on Python (≥ 3.2) and Psycopg (≥ 2.0).

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

Debian GNU/Linux (bullseye)

If you want to install vmm from source, you will also have to install the following both packages:

FreeBSD

Packages or build from ports:

  • dovecot

  • postfix

  • postgresql-client (and postgresql-server, if you do not have a dedicated 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 (5.2)

Packages

  • postfix-2.x.y-pgsql

  • dovecot-2.x.y and dovecot-postgresql-2.x.y

  • postgresql-client

  • python-3.2.x

Build from source

Or build the above mentioned software from ports.

openSUSE Linux

  • postfix and postfix-postgresql

  • postgresql-server and postgresql

  • dovecot

  • python and pyPgSQL optionally python-crypto