From owner-freebsd-questions@FreeBSD.ORG Tue Jul 17 22:34:42 2007 Return-Path: <owner-freebsd-questions@FreeBSD.ORG> X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 3F8CD16A400 for <freebsd-questions@freebsd.org>; Tue, 17 Jul 2007 22:34:42 +0000 (UTC) (envelope-from hoschi@etain.frida.mouhaha.de) Received: from etain.frida.mouhaha.de (etain.frida.mouhaha.de [85.236.48.54]) by mx1.freebsd.org (Postfix) with ESMTP id D9F9513C478 for <freebsd-questions@freebsd.org>; Tue, 17 Jul 2007 22:34:41 +0000 (UTC) (envelope-from hoschi@etain.frida.mouhaha.de) Received: from localhost (etain.frida.mouhaha.de [85.236.48.54]) by etain.frida.mouhaha.de (Postfix) with ESMTP id F24664B3464; Wed, 18 Jul 2007 00:34:39 +0200 (CEST) X-Virus-Scanned: amavisd-new at mouhaha.de Received: from etain.frida.mouhaha.de ([85.236.48.54]) by localhost (etain.frida.mouhaha.de [85.236.48.54]) (amavisd-new, port 10024) with ESMTP id pyJUkCJNVun6; Wed, 18 Jul 2007 00:31:35 +0200 (CEST) Received: by etain.frida.mouhaha.de (Postfix, from userid 1001) id F05344B3490; Wed, 18 Jul 2007 00:28:08 +0200 (CEST) Date: Wed, 18 Jul 2007 00:28:08 +0200 From: Oliver Peter <hoschi@mouhaha.de> To: Tek Bahadur Limbu <teklimbu@wlink.com.np> Message-ID: <20070717222808.GA93337@nemesis.frida.mouhaha.de> References: <469A06D1.4030601@wlink.com.np> <20070717155834.GK46587@nemesis.frida.mouhaha.de> <469D1A7E.6030906@wlink.com.np> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Nq2Wo0NMKNjxTN9z" Content-Disposition: inline In-Reply-To: <469D1A7E.6030906@wlink.com.np> X-Operating-System: FreeBSD 6.2-RELEASE-p2 i386 User-Agent: Mutt/1.5.14 (2007-02-12) Cc: freebsd-questions@freebsd.org Subject: Re: Integrating Postfix + Amavisd-new + Clamav + DSpam + DBmail X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions <freebsd-questions.freebsd.org> List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, <mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe> List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions> List-Post: <mailto:freebsd-questions@freebsd.org> List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help> List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, <mailto:freebsd-questions-request@freebsd.org?subject=subscribe> X-List-Received-Date: Tue, 17 Jul 2007 22:34:42 -0000 --Nq2Wo0NMKNjxTN9z Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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) -=20 > >maybe you would like to try mysql instead (*hirgs*). >=20 > I think that I may have to switch back to Mysql then. I heard that=20 > PostgreSQL is more scalable than Mysql. But I am not an experienced=20 > 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?= =20 > I suppose storing emails in a database should be more scalable and=20 > 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. >=20 > Of course, I would like to see your configuration files. In fact, I am=20 > dying to see it. Hehe, no problem. You will get them tomorrow. Promised. =20 > I am planning my current setup to be used for a long term basis in a=20 > production environment for a very large user base. >=20 > Me and my team are currently just designing and testing it out. It might= =20 > take some time before we can put this server in production. >=20 > Since I am very new to database terminology, how scalable is a database= =20 > in terms of the data storage size. I mean suppose, we have 20000 users=20 > each with a quota of 1 GB. What will eventually happen if they all used= =20 > 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. =20 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. --=20 Oliver PETER, email: hoschi@mouhaha.de, ICQ# 113969174 "Worker bees can leave. Even drones can fly away. The Queen is their slave." --Nq2Wo0NMKNjxTN9z Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.3 (FreeBSD) iEYEARECAAYFAkadQngACgkQ6LH/IUVtaI+PXACgnz5M1Ch3ykCBy0M4z1JMnvHK ZnwAn035OAaExGq4dwLRYqq1zFfhh2W3 =7roC -----END PGP SIGNATURE----- --Nq2Wo0NMKNjxTN9z--