postfix/pgsql-virtual_uid_maps.cf
author martin f. krafft <madduck@madduck.net>
Sun, 08 Apr 2012 00:02:00 +0200
branchv0.6.x
changeset 497 5b9a03762813
parent 486 ccdfbbb1bb01
child 501 f2387d60624b
permissions -rw-r--r--
Add non-root TODO

# 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')