Re: Not ready for 8.3

From: Dave Page <dpage(at)postgresql(dot)org>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Not ready for 8.3
Date: 2007-05-16 17:45:38
Message-ID: 464B4342.5000909@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jim C. Nasby wrote:
> On Wed, May 16, 2007 at 04:34:56PM +0100, Dave Page wrote:
>>> How much visibility do we have into the mhonarc database? We should be
>>> able to come up with a simple redirector that would point the old
>>> mhonarc URLs to URLs for the new system...
>> <cough>database?</cough>
>
> And here I thought the reason we used tho POS was because it was the
> only archiver that used PostgreSQL as it's backend...

You're thinking of the old search engine.

>> It's a file system. It simply generates HTML (or in our case) PHP files
>> from each message in an mbox. That's one of the reasons for the monthly
>> break - without it, the directories would be unusably full of files.
>>
>> I the current URLs represent the month, and the ID of the message as it
>> comes out of the mbox I believe. We could probably write a script to
>> dump a list of message IDs, directories and mbox positions I imagine,
>> and then import that into a new database.
>
> Yeah, if the files still resemble real emails then we can probably come
> up with a way to pull the data in.

We have all the mbox files, so we can import them from there as raw
messages.

>> It's been on my list to rewrite the whole archive system for a while for
>> various reasons. There is quite a bit of crossover with the patch
>> tracker I proposed so I was hoping to look at both together.
>
> Let me know when you start on that...

Roger.

/D

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2007-05-16 17:46:31 Re: Lack of urgency in 8.3 reviewing
Previous Message Joshua D. Drake 2007-05-16 17:38:15 Re: Lack of urgency in 8.3 reviewing