Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D9D929FC1E1 for ; Fri, 13 Jul 2007 16:28:39 -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 40544-07 for ; Fri, 13 Jul 2007 16:28:28 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id EE8E29FC1C6 for ; Fri, 13 Jul 2007 16:28:30 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so691429ugf for ; Fri, 13 Jul 2007 12:28:21 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=H3euyVOJRCkcEFiZsinJ+S8Zf++J5SPKSpyIDLcr96ZwhnVx8CGNnCAvwgnygRnDJ020BEBoS8B13CoobBLruGvdeDEU8Jtnmg++j0NxcsXiC6x4v0xH62QqRfzWXwUorLEz730tUJZmWi0lI+zyjPpU8yPvtrQ3WSK+VTbEUk8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding; b=jR/u1dXkfOmsMWgvEIg7XZycRFYalLytJepYXtezJuNFRrInGHkuKlcM/kv8dB3BZ8e6JlnIIjdJiOvUa2bZUSi3+x58leWtGh002oFZiy0iHFqKgqbjdnaE9oQUkeIKxWPZ57wWzTKmtKBH83nYUeFIR9MU/wQ7XlQ4OMPDpYY= Received: by 10.82.190.2 with SMTP id n2mr2423256buf.1184354901384; Fri, 13 Jul 2007 12:28:21 -0700 (PDT) Received: from ?10.0.0.4? ( [85.71.9.11]) by mx.google.com with ESMTP id f4sm18753877nfh.2007.07.13.12.28.20 (version=TLSv1/SSLv3 cipher=RC4-MD5); Fri, 13 Jul 2007 12:28:20 -0700 (PDT) Message-ID: <4697D250.9090800@gmail.com> Date: Fri, 13 Jul 2007 21:28:16 +0200 From: Rober Mach User-Agent: Thunderbird 1.5.0.12 (X11/20070604) MIME-Version: 1.0 To: "psql-students@postgresql.org" Subject: GSoC project status: PgCheck - Integrity check for data files Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/4 X-Sequence-Number: 83 Hello, 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. Cheers, Robert