Re: Recovering data via raw table and field separators - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Recovering data via raw table and field separators
Date
Msg-id 20071204215024.GE19536@svana.org
Whole thread Raw
In response to Re: Recovering data via raw table and field separators  ("John Wells" <jb@sourceillustrated.com>)
Responses Re: Recovering data via raw table and field separators
List pgsql-general
On Tue, Dec 04, 2007 at 03:05:53PM -0500, John Wells wrote:
> So, given a database table file that still has records in it, and
> given the fact that these records could be parsed and displayed if the
> proper utilty knew how to read the various data structures used to
> denote field and record length, is there no utility to do this? I
> seems that it would be fairly straight forward to somehow read the
> records, yet to pay no mind to the deleted flag (or whatever mechanism
> postgresql uses to mark them as deleted).

Ofcourse, see the pg_filedump mentioned at the beginning of this
thread.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Attachment

pgsql-general by date:

Previous
From: "Obe, Regina"
Date:
Subject: Re: stored procedures and dynamic queries
Next
From: Brian Wipf
Date:
Subject: Re: Disconnects hanging server