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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
