[ADMIN] drive failure

2011-03-31 Thread Tony Capobianco
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

Re: [ADMIN] drive failure

2011-03-31 Thread Tony Capobianco
We were able to determine through a few of our queries that an index was corrupt. We did this through the process of elimination however. As a result, I have two questions: How can I determine that we have a corrupt index? How can I determine which datafile (5875980.x) is related to which

Re: [ADMIN] drive failure

2011-03-31 Thread raghu ram
On Thu, Mar 31, 2011 at 7:11 PM, Tony Capobianco tcapobia...@prospectiv.com wrote: We were able to determine through a few of our queries that an index was corrupt. We did this through the process of elimination however. As a result, I have two questions: How can I determine that we have a