Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 071472E181E for ; Wed, 12 Mar 2008 06:05:14 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 25419-02 for ; Wed, 12 Mar 2008 06:05:02 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.230]) by postgresql.org (Postfix) with ESMTP id 4DEB82E0391 for ; Wed, 12 Mar 2008 06:05:07 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id c49so2060913wra.19 for ; Wed, 12 Mar 2008 02:05:06 -0700 (PDT) Received: by 10.151.10.7 with SMTP id n7mr4390066ybi.6.1205312706330; Wed, 12 Mar 2008 02:05:06 -0700 (PDT) Received: by 10.150.96.5 with HTTP; Wed, 12 Mar 2008 02:05:06 -0700 (PDT) Message-ID: <937d27e10803120205oe273e5asca7473ad05877c87@mail.gmail.com> Date: Wed, 12 Mar 2008 09:05:06 +0000 From: "Dave Page" To: "Joshua D. Drake" Subject: Re: Email not searchable in our archives Cc: "Alvaro Herrera" , "Bruce Momjian" , "PostgreSQL www" In-Reply-To: <20080311152012.3bd779b9@jd-laptop> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200803112135.m2BLZ6625071@momjian.us> <20080311220224.GC6737@alvh.no-ip.org> <20080311152012.3bd779b9@jd-laptop> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/242 X-Sequence-Number: 14361 On Tue, Mar 11, 2008 at 10:20 PM, Joshua D. Drake wrote: > On Tue, 11 Mar 2008 19:02:25 -0300 > Alvaro Herrera wrote: > > > Perhaps I should just try without the subdir and see if it works. > > I am wondering if we should bail out of Mhonarc all together. Do we > actually need it? We have the actual mbox files right? Couldn't we > build our own parser for whatever? As I've mentioned a number of times, I've spent quite a bit of time doing that already - I just don't have the spare cycles to finish right now. We currently have a parser/archiver that will incrementally archive messages from the (growing) mboxes into a database, and a web frontend which resolves many of the problems with the current archives. There are optimisation/performance issues to be solved, as well as some PHP crashes that seem to manifest themselves only on the FreeBSD production server. The mime handling could also use some improvement to properly reconstruct multi-part messages, but in reality I'm not sure we ever have any where that's actually an issue. If anyone else wants to pickup where I've left off, please let me know. -- Dave Page EnterpriseDB UK Ltd: http://www.enterprisedb.com PostgreSQL UK 2008 Conference: http://www.postgresql.org.uk