Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id E1CAC2E01BA for ; Tue, 11 Dec 2007 16:13:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 96616-02 for ; Tue, 11 Dec 2007 16:13:49 -0400 (AST) Received: from web53510.mail.re2.yahoo.com (web53510.mail.re2.yahoo.com [206.190.37.71]) by postgresql.org (Postfix) with SMTP id 2D16A2E00D5 for ; Tue, 11 Dec 2007 16:13:49 -0400 (AST) Received: (qmail 88500 invoked by uid 60001); 11 Dec 2007 20:13:47 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=VcmrhFrURF5Hlrivk2jLsqtyBss+1q2MUlRHvuMrFaqQQqXZIDUf7xTcuKX9dTAcY0nenkchJ9nSPiXu+gJi2L/AUaZlTxdTFDEnYy6Va7NgNe2R+/E8F+fAQAYQUcbGJMubUcZnyHQYEQcOdoEgc6WmwfSRuaAUbY7X9f8KRU0=; X-YMail-OSG: hXKAKFMVM1mEr9eZBkoR47nkgBxXxRHfXWQy6qE_iwoVtqoPi4FOxoJw0Umw6SBkvQ-- Received: from [209.87.232.169] by web53510.mail.re2.yahoo.com via HTTP; Tue, 11 Dec 2007 12:13:47 PST X-Mailer: YahooMailRC/818.31 YahooMailWebService/0.7.158.1 Date: Tue, 11 Dec 2007 12:13:47 -0800 (PST) From: jing han Subject: If postgres database files are corrupted by power failure, how to check which files are corrupted, To: postgres interface MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Message-ID: <449216.79936.qm@web53510.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.383 tagged_above=0 required=5 tests=AWL=0.568, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 200712/3 X-Sequence-Number: 6668 Hello, My postgres database files are corrupted by power failure, I'm going to try to recover the corrupted files, Can you tell me how to check which files are corrupted? Is there any postgres tools can do this? jing ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping