SF.net SVN: postfixadmin:[1682] trunk/DOCUMENTS/POSTFIX_CONF.txt

[<chr...@us...>]

Revision: 1682
          http://sourceforge.net/p/postfixadmin/code/1682
Author:   christian_boltz
Date:     2014-07-22 20:36:22 +0000 (Tue, 22 Jul 2014)
Log Message:
-----------
POSTFIX_CONF.txt:
- add note that active=1 needs to be changed to active='t' when using 
  PostgreSQL
  https://sourceforge.net/p/postfixadmin/discussion/676076/thread/016fe62e/
- move around note about concat() vs. PostgreSQL

Modified Paths:
--------------
    trunk/DOCUMENTS/POSTFIX_CONF.txt

Modified: trunk/DOCUMENTS/POSTFIX_CONF.txt
===================================================================
--- trunk/DOCUMENTS/POSTFIX_CONF.txt	2014-06-21 19:54:24 UTC (rev 1681)
+++ trunk/DOCUMENTS/POSTFIX_CONF.txt	2014-07-22 20:36:22 UTC (rev 1682)
@@ -51,9 +51,15 @@
 
 You can create these files (with your values for user, password, hosts and
 dbname) automatically by executing this file (sh POSTFIX_CONF.txt).
-Please note that the generated files are for use with MySQL. For PostgreSQL,
-you'll have to replace the CONCAT as described below.
+Please note that the generated files are for use with MySQL. 
 
+If you are using PostgreSQL, you'll need to do some changes to the queries:
+- PostgreSQL uses a different implementation for boolean values, which means 
+  you'll need to change  active='1'  to  active='t'  in all queries
+- PostgreSQL does not have a concat() function, instead use e.g. 
+  .... alias.address = '%u' || '@' || alias_domain.target_domain AND ....
+ 
+
 mysql_virtual_alias_maps.cf:
 user = postfix
 password = password
@@ -69,8 +75,6 @@
 dbname = postfix
 query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' and alias.address = CONCAT('%u', '@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
 
-(Note: PostgreSQL does not have a concat() function, instead use e.g. .... alias.address = '%u' || '@' || alias_domain.target_domain AND ....)
- 
 mysql_virtual_alias_domain_catchall_maps.cf:
 # handles catch-all settings of target-domain
 user = postfix

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.