Re: [Sqlgrey-users] multiple databases ?

[Lionel B. <lio...@bo...>]

Steve Heaven wrote the following on 27.09.2005 13:51 :

>
> We have successfully setup sqlgrey on one of our incoming mail servers.


Yes, saw you on postfix-users :-)

> We now need to do the same for our other server.
> We accept mail for ~250 domains. For most of these the two servers are 
> equal MX priority, so they load share and provide backup for each other.
>
> When setting up sqlgrey on the second server should we create a new 
> Postgres database or have them share the existing one?
>
> We thought that sharing would be the best option, but dont know if 
> this will work.
>

Sharing the database is the way to go. It was designed to work this way 
(using several databases would only make the greylisting process slower: 
the messages could be greylisted more than once). Be sure to use SQLgrey 
1.6.6 (there was a rare race condition in the earliest 1.6.x releases in 
multiple SQLgrey instances cases).

Lionel.