postfix/pgsql-virtual_uid_maps.cf
author Pascal Volk <user@localhost.localdomain.org>
Mon, 05 Dec 2011 16:17:01 +0000
branchv0.6.x
changeset 486 ccdfbbb1bb01
parent 159 78b6b06188d3
child 501 f2387d60624b
permissions -rw-r--r--
postfix: Use pgsql functions in query templates where possible.

# 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
# Use this VIEW-based template if you didn't create the pgsql function
# `postfix_virtual_uid_map'.
#query = SELECT uid FROM postfix_uid WHERE address='%s'

# the recommended, function-based template
query = SELECT uid FROM postfix_virtual_uid_map('%u', '%d')