Hi, I am in the process of converting bayes from mysql to postgres. On my running system I make a backup with
# sa-learn --backup > /tmp/bayes.backup I use this file as input on my redhat ( 2... ) testsystem using spamassassin 3.4.4 and postgres 8.3.1 like: # sa-learn --restore bayes.backup I get the following error: ............bayes: seen ([EMAIL PROTECTED]) put [16119] dbg: bayes: seen ([EMAIL PROTECTED]) put [16119] dbg: bayes: seen ([EMAIL PROTECTED]) put [16119] dbg: bayes: seen ([EMAIL PROTECTED]) put [16119] dbg: bayes: seen ([EMAIL PROTECTED]) put [16119] dbg: bayes: seen_put: SQL error: ERROR: invalid byte sequence for encoding "UTF8": 0xd3ce [16119] dbg: bayes: HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding". [16119] dbg: bayes: error inserting msgid in seen table for line: s s [EMAIL PROTECTED] bayes: encountered too many errors (20) while parsing seen lines, reverting to empty database and exiting ERROR: Bayes restore returned an error, please re-run with -D for more information I could of course try and find the offending lines in the file and delete but I'm not sure if this an error that will persist. Any hints? Regards Peter Sorensen/University of Southern Denmark/email: [EMAIL PROTECTED]
