Benny, > i will try postgres also now,
> for mysql i used > $timestamp_fmt_mysql = 1; This one becomes irrelevant with PostgreSQL, you may leave it as it is, or remove it. > @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 ? Just change DBI:mysql: to DBI:Pg:, and adjust database name, host, username and password if necessary. Something like: @storage_sql_dsn = (['DBI:Pg:database=mail_log','vscan','kjhjkhkj']); See man DBD::Pg if you need to specify other details about connection. The clauses do not need adjustments. Mark ------------------------------------------------------------------------- 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/
