Mercurial Mercurial > vmm / annotate
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
postfix/pgsql-virtual_mailbox_domains.cf
author martin f. krafft <madduck@madduck.net>
Sat, 07 Apr 2012 00:45:57 +0200
branchv0.6.x
changeset 492 e5c2b3647971
parent 159 78b6b06188d3
permissions -rw-r--r--
Modify address check query to obtain well-defined result The way in which UNION does not yield the desired result, because (a) UNION merges results and (b) the result order is undefined. This patch changes the query to select the counts as columns and hence provides a well-defined order.
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'














vmm




Repositories index