Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A9F271337B8B for ; Thu, 31 Mar 2011 09:45:41 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 74668-08 for ; Thu, 31 Mar 2011 12:45:24 +0000 (UTC) X-Greylist: delayed 00:06:40.374473 by SQLgrey-1.7.6 Received: from stan.prospectivdirect.com (mail.prospectiv.com [155.212.59.212]) by mail.postgresql.org (Postfix) with SMTP id AB0111337B2F for ; Thu, 31 Mar 2011 09:45:23 -0300 (ADT) Received: (qmail 10292 invoked from network); 31 Mar 2011 12:38:42 -0000 Received: from unknown (HELO ?192.168.1.87?) (192.168.1.87) by 0 with SMTP; 31 Mar 2011 12:38:42 -0000 Subject: drive failure From: Tony Capobianco To: pgsql-admin@postgresql.org Content-Type: text/plain; charset="UTF-8" Date: Thu, 31 Mar 2011 08:38:42 -0400 Message-ID: <1301575122.2019.2.camel@tony1.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.32.2 (2.32.2-1.fc14) Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/291 X-Sequence-Number: 37163 Hello, He had a drive fail in an array and the spare kicked in to replace the failed drive. However, when I query a specific table, I get the below error: ERROR: could not open file "pg_tblspc/16412/PG_9.0_201008051/16419/5875980.7" (target block 2968776487): No such file or directory When I change to this directory, the file in question does not exist. Am I to assume that I'm completely hosed? If the spare kicked in, what happened to the file listed above? Any hints would be most appreciated. Thanks.