author | Pascal Volk <user@localhost.localdomain.org> |
Tue, 27 Aug 2013 21:13:28 +0000 | |
changeset 699 | 4c8e15c2f01b |
parent 491 | 320531aa1280 |
permissions | -rw-r--r-- |
105
0332b85f55e1
Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents:
73
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:
73
diff
changeset
|
2 |
# |
0332b85f55e1
Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents:
73
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:
73
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:
73
diff
changeset
|
13 |
# XXX see create_optional_types_and_functions.pgsql |
0332b85f55e1
Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents:
73
diff
changeset
|
14 |
# * line 9: type sender_login |
0332b85f55e1
Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents:
73
diff
changeset
|
15 |
# * line 26: function postfix_smtpd_sender_login_map + comment above |
0332b85f55e1
Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents:
73
diff
changeset
|
16 |
# |
0332b85f55e1
Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents:
73
diff
changeset
|
17 |
# The SQL query template used to search the database |
491
320531aa1280
postfix: Uncommented the query in pgsql-smtpd_sender_login_maps.cf.
Pascal Volk <user@localhost.localdomain.org>
parents:
159
diff
changeset
|
18 |
query = SELECT login FROM postfix_smtpd_sender_login_map('%u', '%d') |