postfix/pgsql-virtual_mailbox_domains.cf
author "martin f. krafft" <madduck@debian.org>
Tue, 07 Aug 2012 21:54:39 +0000
changeset 583 a479c38931c4
parent 159 78b6b06188d3
permissions -rw-r--r--
If an alias has multiple destinations, multiple records exist, due to the nature of the database. address_list would then return the same alias multiple times, which does not add any information, eats screen space and is potentially confusing. Therefore, we SELECT DISTINCTly from the alias table. Signed-off-by: martin f. krafft <madduck@debian.org> --- VirtualMailManager/common.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
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: 76
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: 76
diff changeset
     2
#
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 76
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: 76
diff changeset
     4
hosts = localhost
11
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     5
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     6
# The user name and password to log into the pgsql server.
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     7
user = postfix
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     8
password = some_password
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
     9
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    10
# The database name on the servers.
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
Pascal Volk <neverseen@users.sourceforge.net>
parents:
diff changeset
    11
dbname = mailsys
7a5bd38c5b98 * 'pgsql-virtual_mailbox_domains.cf'
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: 76
diff changeset
    13
# The SQL query template used to search the database
0332b85f55e1 Updated Postfix PostgreSQL client configuration files
Pascal Volk <neverseen@users.sourceforge.net>
parents: 76
diff changeset
    14
query = SELECT gid FROM postfix_gid WHERE domainname='%s'