i will try postgres olso now, for mysql i used
$timestamp_fmt_mysql = 1; @lookup_sql_dsn = ( ['DBI:mysql:database_for_logs:localhost', 'user', 'password'] ); @storage_sql_dsn = ( ['DBI:mysql:database_for_storage:localhost', 'user', 'password'] ); $sql_select_policy = 'SELECT *,alias.address FROM alias,policy WHERE (alias.policy_id = policy.id) AND (alias.address IN (%k))'; $sql_select_white_black_list = 'SELECT wb FROM wblist,mailaddr WHERE (wblist.rid=?) AND (wblist.sid=mailaddr.id) AND (mailaddr.email IN (%k)) ORDER BY mailaddr.priority DESC'; in amavisd.conf, how do i change to postgres ? -- This message was sent using 100% recycled spam mails. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
