postfix/pgsql-virtual_mailbox_maps.cf
author martin f. krafft <madduck@madduck.net>
Sat, 07 Apr 2012 15:23:14 +0200
branchv0.6.x
changeset 495 612a60e9d558
parent 486 ccdfbbb1bb01
child 501 f2387d60624b
permissions -rw-r--r--
Ignore build files related to Debian packaging During Debian packaging, the package is built in ./debian/vmm/, and quilt is used (./.pc/). Both directories contain only generated files and should hence be ignored from the perspective of Mercurial.
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
105
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 0
diff changeset
     1
# All parameters are described in pgsql_table(5) / PGSQL PARAMETERS
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 0
diff changeset
     2
#
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 0
diff changeset
     3
# The hosts that Postfix will try to connect to and query from.
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 0
diff changeset
     4
hosts = localhost
0
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     5
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     6
# The user name and password to log into the pgsql server.
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     7
user = postfix
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     8
password = some_password
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     9
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    10
# The database name on the servers.
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    11
dbname = mailsys
bb0aa2102206 Initial import @sf.net
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    12
105
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 0
diff changeset
    13
# The SQL query template used to search the database
486
ccdfbbb1bb01 postfix: Use pgsql functions in query templates where possible.
Pascal Volk <user@localhost.localdomain.org>
parents: 159
diff changeset
    14
# Use this VIEW-based template if you didn't create the pgsql function
ccdfbbb1bb01 postfix: Use pgsql functions in query templates where possible.
Pascal Volk <user@localhost.localdomain.org>
parents: 159
diff changeset
    15
# `postfix_virtual_mailbox_map'.
ccdfbbb1bb01 postfix: Use pgsql functions in query templates where possible.
Pascal Volk <user@localhost.localdomain.org>
parents: 159
diff changeset
    16
#query = SELECT maildir FROM postfix_maildir WHERE address='%s'
ccdfbbb1bb01 postfix: Use pgsql functions in query templates where possible.
Pascal Volk <user@localhost.localdomain.org>
parents: 159
diff changeset
    17
ccdfbbb1bb01 postfix: Use pgsql functions in query templates where possible.
Pascal Volk <user@localhost.localdomain.org>
parents: 159
diff changeset
    18
# the recommended, function-based template
ccdfbbb1bb01 postfix: Use pgsql functions in query templates where possible.
Pascal Volk <user@localhost.localdomain.org>
parents: 159
diff changeset
    19
query = SELECT maildir FROM postfix_virtual_mailbox_map('%u', '%d')