| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Heikki Linnakangas | 2008-04-29 13:52:30 | Re: table format specification |
| Previous Message | Gregory Stark | 2008-04-29 13:36:02 | Re: Protection from SQL injection |