Re: [HACKERS] pgcheck - data integrity check

2007-08-11 Thread Rober Mach
Josh Berkus wrote: > Robert, > > >> I am working on a data integrity check tool (pgcheck). >> I would like to discuss the following issues: >> > > I'm a little confused. I assumed that your project would check the pages of > a > *shut-down* database or one in recovery (single-user) mod

Re: [HACKERS] pgcheck - data integrity check

2007-08-11 Thread Josh Berkus
Robert, > I am working on a data integrity check tool (pgcheck). > I would like to discuss the following issues: I'm a little confused. I assumed that your project would check the pages of a *shut-down* database or one in recovery (single-user) mode as part of recovery after a crash or HW fail

Re: [HACKERS] pgcheck - data integrity check

2007-08-10 Thread Decibel!
On Fri, Aug 10, 2007 at 05:48:08AM +0200, Rober Mach wrote: > . In near future, I would like to extend the functionality also with a > recovery tool which would be able to repair broken pages. Should the > function also repair the corrupted data on a page, the AccessShare lock > on a relation would

[HACKERS] pgcheck - data integrity check

2007-08-09 Thread Rober Mach
Hi, I am working on a data integrity check tool (pgcheck). I would like to discuss the following issues: Right now I am working on a function, which should check the validity of pages in relation. The relation is passed to the function as its argument (its oid). For the integrity check of a page,