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) -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]