Re: table format specification - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: table format specification
Date
Msg-id 20080429134256.GE3146@svana.org
Whole thread Raw
In response to table format specification  ("PontoSI - Consultoria, Informática e Serviços LDA" <geral@pontosi.pt>)
List pgsql-hackers
On Tue, Apr 29, 2008 at 02:19:24PM +0100, "PontoSI - Consultoria, Informática e Serviços LDA" wrote:
> I'm writing a small program to recover specific tables from a severely
> crippled database, and while I'm able to identify most fields on a hex
> dump of the table file, there are several 'gaps' (probably headers and
> footers and/or additional info) that I can't identify. Where can I find
> documentation regarding the table file layout? I'm working with files
> generated with Postgres 8.25.

There's the manual which has quite a bit of detail. If you want code
there are pg_filedump and pgfsck which can parse datafiles (as long as
your database is in some kind of readable state).

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

pgsql-hackers by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Protection from SQL injection
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: table format specification