Bug#322142: RFP: pgfsck -- PostgreSQL table checker and dumper
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)
Reply to: