| From: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
|---|---|
| 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:52:30 |
| Message-ID: | 4817281E.3040707@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
The file itself consists of 8k pages. src/include/storage/bufpage.h and
src/include/access/htup.h would be a good place to start on
understanding the page layout. There's also a chapter in the manual
about it.
You might also want to take a look at the pageinspect contrib module, in
8.3.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-04-29 14:06:28 | Re: [HACKERS] Proposed patch - psql wraps at window width |
| Previous Message | Martijn van Oosterhout | 2008-04-29 13:42:56 | Re: table format specification |