Michael Parker wrote: > Hmmm....maybe some of the above should be captured in the documentation, > >patches welcome. > > > Nevermind, this is what I just added to UPGRADE, hopefully that make things clearer:
+- As of 3.1.0, in addition to the generic BayesSQL support (via + Mail::SpamAssassin::BayesStore::SQL) usable by multiple database + drivers there is now specific support for MySQL 4.1+ and + PostgreSQL. This support is based on non-standard features present + in both database servers that allow for various performance boosts. + + If you were using the previous BayesSQL support with MySQL, and + already have MySQL 4.1+ installed you can begin using the new module + immediately by replacing the bayes_store_module line in your + configuration with: Mail::SpamAssassin::BayesStore::MySQL + + We do however recommend that you switch your MySQL tables over to + InnoDB for better data integrity and multi user support. You can + most often do this via a simple ALTER TABLE command, refer to the + MySQL documentation for more information. + + If you were previously using PostgreSQL for your bayes database then + we STRONGLY recommend switching to the PostgreSQL specific backend: + Mail::SpamAssassin::BayesStore::PgSQL + To switch to this backend you should first run sa-learn --backup to + make a backup of your existing data and then drop and recreate the + database following the instructions in sql/README.bayes. Then you + can restore the database with sa-learn --restore. If you have + multiple users then you will have to run --backup and --restore for + each user to fully restore the database. Michael
signature.asc
Description: OpenPGP digital signature
