Skip site navigation (1) Skip section navigation (2)

Re: table format specification

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: PontoSI - Consultoria, Informática e Serviços LDA <geral(at)pontosi(dot)pt>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: table format specification
Date: 2008-04-29 13:42:56
Message-ID: 20080429134256.GE3146@svana.org (view raw or flat)
Thread:
Lists: 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(at)svana(dot)org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while 
> boarding. Thank you for flying nlogn airlines.

In response to

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2008-04-29 13:52:30
Subject: Re: table format specification
Previous:From: Gregory StarkDate: 2008-04-29 13:36:02
Subject: Re: Protection from SQL injection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group