postfix/pgsql-virtual_mailbox_domains.cf
author martin f. krafft <madduck@madduck.net>
Fri, 13 Apr 2012 17:49:14 +0200
branchv0.6.x
changeset 530 95dd123b552e
parent 159 78b6b06188d3
permissions -rw-r--r--
Modify SQL update script to accept NULL fields for users The value NULL in the qid/ssid/tid fields of the user table means that the value from the associated domain record should be used instead. This patch modifies the PL/pgSQL functions used by Dovecot and Postfix accordingly.

# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS
#
# The hosts that Postfix will try to connect to and query from.
hosts = localhost

# The user name and password to log into the pgsql server.
user = postfix
password = some_password

# The database name on the servers.
dbname = mailsys

# The SQL query template used to search the database
query = SELECT gid FROM postfix_gid WHERE domainname='%s'