[Maia-users] Postgresql Bayes problem

[Marc G. Fournier]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Just an FYI ... I found mysql totally unstable for production use, personally 
...


- --On Tuesday, July 31, 2007 17:07:03 +0200 Jeffrey Schilperoord 
<jeffrey at schilperoord.org> wrote:

> I havent looked into the postgresql performance problems yet. But if the
> performance with mysql is better and the traffic increases(solves the
> mysql server has gone away issue) when we go live then its no use for me
> to test this setup further. So i will keep using mysql. And skip the
> postgresql problem.
>
> Thanks for the info,
>
> Jeffrey Schilperoord
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Jeffrey Schilperoord wrote:
>> HI,
>>
>>
>>
>> At the company im working at where looking to test maia mailguard in
>> live situation somewhere in the fall. I?ve been testing maia on my
> home
>> server with mysql and it Works perfectly except some ?mysql server has
>> gone away? errors in the beginning.
>
> That is usually caused by connection timeouts on low traffic sites, such
> as test
> servers.  It goes away when you get more traffic.
>
>
>  So when i had to install the  test
>> environment i decided to install it with postgresql because that is
>> supposed to be faster and because of the problems I encountered with
> the
>> mysql solution.
>
> Um, where did you get this idea?  Several threads on this list have been
> about
> poor performance on postgresql.   We develop Maia on mysql, and it's
> what we are
> more familiar with; I realize that it could be a tuning issue but so far
> no one
> has provided a solid answer.
>
>> ERROR:  invalid input syntax for type bytea
>> The bayes_token table is filled anyway but this error comes like 50
>> times a day(during process-quarantine.pl) This is the software im
> using:
>> Freebsd 6.2, postfix-2.4.1,postgresql-server-8.2.4,maia 1.0.2A
>
> I think I've seen similar problems, but the only hit I get in the Maia
> tickets
> is https://www.maiamailguard.com/maia/ticket/302
>
> IIRC, they changed postgresql to be more strict about this, I'm not sure
> about
> it. In any event, that is bayes code, which is handled by spamassassin.
> What
> version of spamassassin are you using?  Make sure you are using the
> postgresql
> specific sql driver in your spamassassin local.cf
>
> bayes_store_module	Mail::SpamAssassin::BayesStore::PgSQL
>
>
> - --
> David Morton
> Maia Mailguard                        - http://www.maiamailguard.com
> Morton Software Design and Consulting - http://www.dgrmm.net
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFGr0TEUy30ODPkzl0RAsheAJ0X+lNLPlk07egccgQllqKbFad/rgCffHNl
> kxQ3XTgVeCReqnXI6yOqL5o=
> =bp5o
> -----END PGP SIGNATURE-----
> _______________________________________________
> Maia-users mailing list
> Maia-users at renaissoft.com
> http://www.renaissoft.com/mailman/listinfo/maia-users



- ----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email . scrappy at hub.org                              MSN . scrappy at hub.org
Yahoo . yscrappy               Skype: hub.org        ICQ . 7615664
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (FreeBSD)

iD8DBQFGu3ET4QvfyHIvDvMRAsJdAJ9q7oxufe20TeD3DM4DCZeqaDemDQCgpdlZ
AR/gk6IQgAxa0F3Ys2ohr/k=
=rGpy
-----END PGP SIGNATURE-----