Re: Documentation on page files - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: Documentation on page files
Date
Msg-id 1019546122.32245.3.camel@taru.tm.ee
Whole thread Raw
In response to Re: Documentation on page files  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Documentation on page files
List pgsql-hackers
On Tue, 2002-04-23 at 01:29, Martijn van Oosterhout wrote:
> 
> The dumping is more of an extra, the original idea was to check for errors
> in the datafiles. Hence the working name of "pgfsck". At the moment the
> dumping dumps only tuples where xmax == 0 but I'm not sure if that's
> correct.

AFAIK it is not. As Tom once explained me, it is ok for tuples xmax to
be !=0 and still have a valid tuple. The validity is determined by some
bits in tuple header.


But I think the most useful behaviour should be to dump system fields
too, so mildly knowledgeable sysadmin can import the dump and do the
right thing afterwards (like restore data as it was before transaction
nr 7000)

-------------
Hannu



pgsql-hackers by date:

Previous
From: cbbrowne@cbbrowne.com
Date:
Subject: Re: "make report"
Next
From: Dave Page
Date:
Subject: Re: Implement a .NET Data