Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4D3319FA508 for ; Sun, 15 Jul 2007 14:47:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 50211-05 for ; Sun, 15 Jul 2007 14:47:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail01.enterprisedb.com (mail01.enterprisedb.com [63.246.7.168]) by postgresql.org (Postfix) with ESMTP id E59049FA4D8 for ; Sun, 15 Jul 2007 14:47:22 -0300 (ADT) thread-index: AcfHCDYGez+enf57TdS+1C8yNE8Gdg== Received: from [192.168.0.5] ([85.211.164.164]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.3959); Sun, 15 Jul 2007 13:47:27 -0400 Content-Class: urn:content-classes:message Importance: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4073 Subject: Re: GSoC project status: PgCheck - Integritycheck for data files From: "Simon Riggs" To: "Rober Mach" Cc: "psql-students@postgresql.org" In-Reply-To: <4699F60C.1090809@gmail.com> References: <4699F60C.1090809@gmail.com> Content-Type: text/plain; charset="iso-8859-1" Date: Sun, 15 Jul 2007 18:47:53 +0100 Message-ID: <1184521673.4512.349.camel@ebony.site> MIME-Version: 1.0 X-Mailer: Evolution 2.8.2 Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 15 Jul 2007 17:47:28.0078 (UTC) FILETIME=[35DE5EE0:01C7C708] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/8 X-Sequence-Number: 87 On Sun, 2007-07-15 at 12:25 +0200, Rober Mach wrote: > I am working on the GSoC project : PgCheck - Integrity check for data files. > Unfortunately, this project is still in its beginning, because my > examination period was during the June. Right now I am working on > function, which will check the validity of indexes according to the > indexed table. This test should be one of various tests that should > check the integrity of data stored in database. > As other things that should be tested in order to check the validity of > data I see: > -check whether the constrains applied on items are fulfilled > -in case of variable-length data, compare the formal and actual size of > data > -check integrity of data pages > -etc. > I would be happy to hear any comments or recommendation on what should > be checked in order to validation of data integrity. > I have opened project on PgFoundry called: PgCheck-Integrity check for > data files. (just waiting for acceptance). > I will keep updating the status of my project. I think this and all GSoC projects should be discussed on -hackers. Please can you repost your ideas there? There is no need to mention GSoC there; we can handle all admin issues on this list. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com