[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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

-- 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: