X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0CF4B5285F for ; Fri, 5 Aug 2005 03:30:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 15172-02 for ; Fri, 5 Aug 2005 06:30:24 +0000 (GMT) Received: from strippy.vizija.si (strippy.vizija.si [217.72.81.150]) by svr1.postgresql.org (Postfix) with ESMTP id B440E52A9E for ; Fri, 5 Aug 2005 03:30:21 -0300 (ADT) Received: from cartman.dev (BSN-95-243-216.dsl.siol.net [193.95.243.216]) by strippy.vizija.si (Postfix) with ESMTP id CA6A0A6C63; Fri, 5 Aug 2005 08:30:26 +0200 (CEST) Received: from cartman.dev (localhost [127.0.0.1]) by cartman.dev (Postfix) with ESMTP id D3F9ED4C56; Fri, 5 Aug 2005 08:33:16 +0200 (CEST) Received: from [10.0.1.31] (aljaz.vizija.local [10.0.1.31]) by cartman.dev (Postfix) with ESMTP id 94503D4C2D; Fri, 5 Aug 2005 08:33:16 +0200 (CEST) Message-ID: <42F30777.9050207@vizija.si> Date: Fri, 05 Aug 2005 08:30:15 +0200 From: =?ISO-8859-2?Q?Alja=BE_Bizjak_Zupanc?= User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Blackfin Cc: pgsql-admin@postgresql.org Subject: Re: Data integrity check when bad sectors occur References: <1123194723.256769.302250@g43g2000cwa.googlegroups.com> In-Reply-To: <1123194723.256769.302250@g43g2000cwa.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Scanned: amavisd-new at vizija.si X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200508/83 X-Sequence-Number: 18402 You can try with pgfsck. It works with the 7.x version only, though. http://svana.org/kleptog/pgsql/pgfsck.html Blackfin wrote: >Is there a way to run a check in PostgreSQL to validate each of the >records when there is bad records or etc? > > >---------------------------(end of broadcast)--------------------------- >TIP 5: don't forget to increase your free space map settings > > > -- Regards, Aljaz mailto:aljaz@vizija.si