postfix/pgsql-virtual_uid_maps.cf
author martin f. krafft <madduck@madduck.net>
Mon, 09 Apr 2012 17:45:02 +0200
branchv0.6.x
changeset 503 492c179094c9
parent 501 f2387d60624b
permissions -rw-r--r--
Add database table for catchall destinations Catch-all aliases are stored for a domain. Since there can be multiple destinations per domain, this is done using a 1:n relation on the gid. This commit extends the SQL schema definition and also provides appropriate upgrade DDL.

# 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 uid FROM postfix_virtual_uid_map('%u', '%d')