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 A5AA85E487C for ; Tue, 7 Sep 2004 19:25:34 +0100 (BST) 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 02158-02 for ; Tue, 7 Sep 2004 18:25:30 +0000 (GMT) Received: from twosensemedia.com (busicast.com [69.15.36.138]) by svr1.postgresql.org (Postfix) with ESMTP id 45F895E4813 for ; Tue, 7 Sep 2004 19:25:28 +0100 (BST) Received: from [10.0.1.128] (account wbishop@busicast.com HELO S0030153310) by twosensemedia.com (CommuniGate Pro SMTP 4.0.6) with ESMTP id 2501160 for pgsql-admin@postgresql.org; Tue, 07 Sep 2004 14:25:01 -0400 Message-ID: <003801c49508$59b8d960$1900a8c0@S0030153310> From: "Worth Bishop" To: Subject: Recover from data corruption? Date: Tue, 7 Sep 2004 14:27:36 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/102 X-Sequence-Number: 14805 I'm a novice PostgreSQL admin, running 7.2 on FreeBSD 4.6. I copied a directory containing a web application that interfaces with a PostgreSQL database. First time the application was accessed, the system indicated the database was not running. Restarted the database, no PostgeSQL errors in logfile or at console. However, now each time a request is made against the database, the server console displays the following error: ad0s1f: hard error reading fsbn 91219263 of 4145297 - 41415327 (ad0s1 bn 91219263; cn 5678 tn 34 sn 51) trying PIO mode ad0: DMA problem fallback to PIO mode Then, repeated messages: ad0s1f: hard error reading fsbn 91219279 of 4145296 - 41415327 (ad0s1 bn 91219279; cn 5678 tn 35 sn 4) status=59 error=40 I can access the database using psql. The error message suggests a hard drive trying to die, but since it came hard on the heels of my actions, I have to believe I've corrupted the data. Is there any way to reindex or otherwise recover from this? Any thoughts or suggestions? Thanks.