| author | Pascal Volk <user@localhost.localdomain.org> |
| Mon, 27 Jan 2014 21:27:21 +0000 | |
| changeset 702 | 01db2457bbed |
| 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') |