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...
> 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. > 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... -- Jim Nasby [EMAIL PROTECTED] EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org