| author | martin f. krafft <madduck@madduck.net> |
| Sun, 08 Apr 2012 11:54:17 +0200 | |
| branch | v0.6.x |
| changeset 498 | 419c929739fd |
| parent 486 | ccdfbbb1bb01 |
| child 501 | f2387d60624b |
| permissions | -rw-r--r-- |
|
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_relocated_map'. |
|
ccdfbbb1bb01
postfix: Use pgsql functions in query templates where possible.
Pascal Volk <user@localhost.localdomain.org>
parents:
159
diff
changeset
|
16 |
#query = SELECT destination FROM postfix_relocated 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 destination FROM postfix_relocated_map('%u', '%d') |