Good Day Im having problems with Spamassassin Bayes using Postgresql as Backend.
SA perfectly learns Ham&Spam as you can see: bayesstore=# select count(*) from bayes_seen; count ------- 2669 Debugging output seems fine too: spamassassin -D < ~/some_allready_learned.eml Returns: [91874] dbg: bayes: using username: amavis [91874] dbg: bayes: database connection established [91874] dbg: bayes: found bayes db version 3 [91874] dbg: bayes: Using userid: 6 Loaded the bayes_store_module in local.cf: bayes_store_module Mail::SpamAssassin::BayesStore::PgSQL I first thought that it maybe is an Encoding Problem so I tried SQL_ASCII, LATIN1, UTF8 but got the same results. So im kinda out of Ideas now, only gotta say that I haven't used Postgresql for years, was only using Mysql but now I switched again, so I bet I've been overlooking Stuff. To create the Schema Ive used http://svn.apache.org/viewvc/spamassassin/trunk/sql/bayes_pg.sql?revision=579680&pathrev=579680 These are the error messages I get flooded with: http://pastebin.com/m1c8d0321 http://pastebin.com/f528752f9 Cheers -- Tobias Lott