Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail

[Oliver Peter]

On Wed, Jul 18, 2007 at 01:22:34AM +0545, Tek Bahadur Limbu wrote:
> Oliver Peter wrote:
> ...
> >On Sun, Jul 15, 2007 at 05:21:49PM +0545, Tek Bahadur Limbu wrote:
> >I would like to switch back to a filesystem based e-mail backend
> >(maybe dovecot) - feels better to me.  Furthermore I think that dbmail
> >has no good pgsql support (it has some bugs with IMAP) - 
> >maybe you would like to try mysql instead (*hirgs*).
> 
> I think that I may have to switch back to Mysql then. I heard that 
> PostgreSQL is more scalable than Mysql. But I am not an experienced 
> database user, so, please forgive my little knowledge.

Personally I prefer PostgreSQL.  It works great for me.
In my opinion MySQL is to Postgres like Linux to FreeBSD :)

Serious:
I had a little problem with dbmail and pgsql:
http://www.mail-archive.com/dbmail@dbmail.org/msg11640.html

I haven't tried the new version yet.

> Why do you want to switch back to to a filesystem based e-mail backend? 
> I suppose storing emails in a database should be more scalable and 
> flexible in the long run?

Since I'm the only active user of my dbmail setup it's too oversized
for this purpose.  I think I can live with a small filesystem based
postfix setup, too.
Of course it will be more flexible in the long run but I have only a
1,2ghz machine as my main mailserver - simply it is too slow.

> >If you would like I can show you my configuration files and table
> >structures.
> 
> Of course, I would like to see your configuration files. In fact, I am 
> dying to see it.

Hehe, no problem.  You will get them tomorrow.  Promised.
 
> I am planning my current setup to be used for a long term basis in a 
> production environment for a very large user base.
> 
> Me and my team are currently just designing and testing it out. It might 
> take some time before we can put this server in production.
> 
> Since I am very new to database terminology, how scalable is a database 
> in terms of the data storage size. I mean suppose, we have 20000 users 
> each with a quota of 1 GB. What will eventually happen if they all used 
> up their quotas. That will be about 20 TB in size!!

w00t - as you can see I'm just a little sysadmin managing his very own
small mailserver.  I never thought about thousands of user - I never
thought about to have more than 10 user. Hehe.

Well, if you will have such a huge load Postgres would be the best
choice for you.  As far as -> I <- know it has better methods
regarding failover, master- and slaveserver and of course db clusters.  

I think one main 'problem' with dbmail will be that if your db crashes
or stops working  EVERYTHING  is lost.  You don't have these problems
in this dimension with a filesystem based mailsystem.  Primarily you
will have to find a good backup/failover solution for your database -
regardless of what system you will use (pgsql, mysql, oracle,
mssql... SQLlite ...)

> Thanking you...

Let's see if my small setup will help you tomorrow.  I will get in
touch with you.

-- 
Oliver PETER, email: hoschi at mouhaha.de, ICQ# 113969174
"Worker bees can leave. Even drones can fly away. The Queen is their slave."
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20070717/83ea631b/attachment.pgp