Re: Not ready for 8.3 - Mailing list pgsql-hackers

From Magnus Hagander
Subject Re: Not ready for 8.3
Date
Msg-id 464C050B.1080902@hagander.net
Whole thread Raw
In response to Re: Not ready for 8.3  ("Jim C. Nasby" <decibel@decibel.org>)
Responses Re: Not ready for 8.3  (Dave Page <dpage@postgresql.org>)
List pgsql-hackers
Jim C. Nasby wrote:
> On Wed, May 16, 2007 at 07:48:10PM +0200, Magnus Hagander wrote:
>> Dave Page wrote:
>>>>> 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.
>> yeah, that's clearly the best source to work from. It's *possible* work
>> from the mhonarc files (I've done it before), but it's more work.
> 
> We'd want the old URLs to be redirected too, so at some point we'll have
> to deal with mhonarc.

Right. Grabbing the msgid alone from them shouldn't be too hard though.
It's included in the "meta-headers" mhonarc sticks in each file, so it
should be a simple regex to find it.

//Magnus



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BufFileWrite across MAX_PHYSICAL_FILESIZE boundary
Next
From: Dave Page
Date:
Subject: Re: Lack of urgency in 8.3 reviewing