X-Original-To: pgsql-www-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id BC9209FA6B5; Wed, 9 Aug 2006 16:27:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 45073-05; Wed, 9 Aug 2006 19:27:42 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- X-Greylist: domain auto-whitelisted by SQLgrey- Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id EE1F79FA48B; Wed, 9 Aug 2006 16:27:41 -0300 (ADT) Received: from localhost (wm.hub.org [200.46.204.128]) by hub.org (Postfix) with ESMTP id 24791291B00; Wed, 9 Aug 2006 16:27:39 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 40830-07; Wed, 9 Aug 2006 19:27:38 +0000 (UTC) Received: from ganymede.hub.org (blk-224-179-167.eastlink.ca [24.224.179.167]) by hub.org (Postfix) with ESMTP id 11B0D290C20; Wed, 9 Aug 2006 16:27:35 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id CDEC63F1BF; Wed, 9 Aug 2006 16:27:38 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id C7F9233DF1; Wed, 9 Aug 2006 16:27:38 -0300 (ADT) Date: Wed, 9 Aug 2006 16:27:38 -0300 (ADT) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: "Marc G. Fournier" cc: Bruce Momjian , PostgreSQL www , Tom Lane Subject: Re: Mail archive indexes are broken, URLs too In-Reply-To: <20060809141747.C7267@ganymede.hub.org> Message-ID: <20060809162654.V7267@ganymede.hub.org> References: <200608011911.k71JBQl12986@momjian.us> <20060809141747.C7267@ganymede.hub.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.381 tagged_above=0 required=5 WHITELISTED tests=DNS_FROM_RFC_ABUSE, FORGED_RCVD_HELO, RCVD_IN_SORBS_DUL X-Spam-Level: ** X-Archive-Number: 200608/63 X-Sequence-Number: 10454 'k, rsync is back up ... for a short period, part of the archives will disappear, but a large portion of it is re-generated, and figured may as well let the 'feed server' start downloading now :) On Wed, 9 Aug 2006, Marc G. Fournier wrote: > > Just shutdown rsync while I rebuild the archives for the 'old/new' scheme, > where old is pre-July 2006 ... > > will post once its been all rebuilt ... > > On Tue, 1 Aug 2006, Bruce Momjian wrote: > >> >> Is anyone working on this? Marc? If not, who can make these >> modifications to the archive numbering? >> >> --------------------------------------------------------------------------- >> >> Bruce Momjian wrote: >>> Tom Lane wrote: >>>> When Marc fixed the message-boundary pattern and regenerated the >>>> archives, many of the existing messages changed URLs because they >>>> got assigned slightly different numbers. I notice that the archive >>>> search engine hasn't yet tracked this change --- if you do a search >>>> and click on a link to a message, you'll arrive at a message close >>>> to the one you want but probably not quite it. >>>> >>>> Regenerating the archive indexes is presumably not hard, but there's >>>> a bigger problem: for awhile now many of us have been in the habit >>>> of citing old discussions by archive URLs. All those links are now >>>> broken too, and I can't think of any easy way to fix them. And then >>>> there's Google etc. >>>> >>>> I wonder if it'd be better to revert the regeneration of the archives, >>>> and only apply the new message-boundary pattern to future messages. >>> >>> Agreed. There have been no changes since we discussed this. >>> >>> The best proposal was to renumber the newly-found items to the end of >>> the numeric range for the pre-July 2006 archives, and to properly number >>> July 2006 and later archives. And this date range has to be enbedded in >>> the archive script so if it is ever run again, this behavior continues >>> to happen. >>> >>> The longer we take to fix this, the more likely that people are creating >>> URL's that refer to the existing pre-July 2006 numbering which should >>> change. It needs to be fixed quickly. >>> >>> And we can't just leave it alone because old archive emails have URLs >>> that point to now-incorrect numbers, and there is no good way to fix >>> that everywhere are emails are archived. >>> >>> -- >>> Bruce Momjian bruce@momjian.us >>> EnterpriseDB http://www.enterprisedb.com >>> >>> + If your life is a hard drive, Christ can be your backup. + >>> >>> ---------------------------(end of broadcast)--------------------------- >>> TIP 4: Have you searched our list archives? >>> >>> http://archives.postgresql.org >> >> -- >> Bruce Momjian bruce@momjian.us >> EnterpriseDB http://www.enterprisedb.com >> >> + If your life is a hard drive, Christ can be your backup. + >> > > ---- > Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) > Email . scrappy@hub.org MSN . scrappy@hub.org > Yahoo . yscrappy Skype: hub.org ICQ . 7615664 > ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664