Bug#322142: marked as done (ITP: pgfsck -- PostgreSQL table checker and dumper)
Your message dated Fri, 25 Nov 2005 02:38:10 +0000
with message-id <43867912.9080609@wayforth.co.uk>
and subject line Upstream dead
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 9 Aug 2005 09:44:25 +0000
>From jari.aalto@cante.net Tue Aug 09 02:44:25 2005
Return-path: <jari.aalto@cante.net>
Received: from fep30-0.kolumbus.fi (fep30-app.kolumbus.fi) [193.229.0.32]
by spohr.debian.org with esmtp (Exim 3.36 1 (Debian))
id 1E2Qem-0006wB-00; Tue, 09 Aug 2005 02:44:25 -0700
Received: from bongo.cante.net ([81.197.3.110]) by fep30-app.kolumbus.fi
with ESMTP
id <20050809094423.LJAY8394.fep30-app.kolumbus.fi@bongo.cante.net>
for <submit@bugs.debian.org>; Tue, 9 Aug 2005 12:44:23 +0300
Received: from mx2.cante.net ([192.168.1.3] helo=cante.cante.net)
by bongo.cante.net with esmtp (Exim 4.52)
id 1E2Qek-0003Cz-Lh; Tue, 09 Aug 2005 12:44:22 +0300
Received: from jaalto by cante.cante.net with local (Exim 4.52)
id 1E2Qel-0002Ua-1P; Tue, 09 Aug 2005 12:44:23 +0300
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Jari Aalto <jari.aalto@cante.net>
To: Debian Bug Tracking System <submit@bugs.debian.org>
Subject: RFP: pgfsck -- PostgreSQL table checker and dumper
X-Mailer: reportbug 3.15
Date: Tue, 09 Aug 2005 12:44:22 +0300
Message-Id: <E1E2Qel-0002Ua-1P@cante.cante.net>
Delivered-To: submit@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-8.0 required=4.0 tests=BAYES_00,HAS_PACKAGE
autolearn=no version=2.60-bugs.debian.org_2005_01_02
Package: wnpp
Severity: wishlist
* Package name : pgfsck
Version : 0.14
Upstream Author : Martijn van Oosterhout <kleptog@svana.org>
* URL : http://svana.org/kleptog/pgsql/pgfsck.html
* License : GPL
Description : PostgreSQL table checker and dumper
(Include the long description here.)
This program serves three purposes (up tp PG 7.3):
To identify problems with PostgreSQL data files
Occasionally people post to the mailing list saying that doing a
select * from table crashes PostgreSQL. Obviously there's a problem
somewhere. Usually it can be solved by searching for the damaged tuple
and deleting it. This can be time consuming. This program should be
able to identify the right tuple right off. To make it easier for
developers to get examples of corrupted files.
When corruption happens you'd like to know what caused
it. Unfortunatly getting people to attach a table to an email is
impractical and it's difficult to tell the problem from that. One plan
is to provide a way to dump the affected pages to a file, thus making
the problem much easier to find. Dumping program of last resort
Sometimes people do silly things like deleting their xlog or trying to
upgrade their postmaster without doing a pg_dump first. Anyway, since
this program does not require the postmaster to be running, it can
recover data in all sorts of situations where it would otherwise be
difficult.
-- System Information:
Debian Release: testing/unstable
APT prefers unstable
APT policy: (500, 'unstable'), (500, 'stable'), (1, 'experimental')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/bash
Kernel: Linux 2.6.11-1-686
Locale: LANG=C, LC_CTYPE=C (charmap=ISO-8859-1) (ignored: LC_ALL set to en_US)
---------------------------------------
Received: (at 322142-done) by bugs.debian.org; 25 Nov 2005 02:35:02 +0000
>From antony@wayforth.co.uk Thu Nov 24 18:35:02 2005
Return-path: <antony@wayforth.co.uk>
Received: from heisenberg.zen.co.uk ([212.23.3.141])
by spohr.debian.org with esmtp (Exim 4.50)
id 1EfTQU-0004xC-B9
for 322142-done@bugs.debian.org; Thu, 24 Nov 2005 18:35:02 -0800
Received: from [82.68.107.174] (helo=[192.168.1.64])
by heisenberg.zen.co.uk with esmtp (Exim 4.30)
id 1EfTQT-0003eR-BV
for 322142-done@bugs.debian.org; Fri, 25 Nov 2005 02:35:01 +0000
Message-ID: <43867912.9080609@wayforth.co.uk>
Date: Fri, 25 Nov 2005 02:38:10 +0000
From: Antony Gelberg <antony@wayforth.co.uk>
User-Agent: Mozilla Thunderbird 1.0.7 (X11/20051013)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: 322142-done@bugs.debian.org
Subject: Upstream dead
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Originating-Heisenberg-IP: [82.68.107.174]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2005_01_02
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Level:
X-Spam-Status: No, hits=-3.0 required=4.0 tests=BAYES_00 autolearn=no
version=2.60-bugs.debian.org_2005_01_02
I was going to package this. However, upstream is dead (last release
July 2003), it only supports PostgreSQL up to 7.3, and it doesn't look
like that's going to change anytime soon. See author's comments:
| > On Tue, Aug 30, 2005 at 03:41:54AM +0100, Antony Gelberg wrote:
| >
| > Hi,
| >
| > I'm planning to package pgfsck for Debian. Will you be updating it | to
| > work with pgsql versions later than 7.3?
|
| Maybe, maybe not. I actually have a 7.4 database now to test it on, | but
| I havn't really needed it yet...
|
| It's not exactly a well tested tool and could do with some real
| regression testing...
So I'm closing the ITP: low quality, dead upstream, and doesn't even
work with the version of postgresql in stable.
Reply to: