Skip site navigation (1) Skip section navigation (2)

drive failure

From: Tony Capobianco <tcapobianco(at)prospectiv(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: drive failure
Date: 2011-03-31 12:38:42
Message-ID: 1301575122.2019.2.camel@tony1.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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:  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.



pgsql-admin by date

Next:From: bilal ghayyadDate: 2011-03-31 12:52:09
Subject: Re: ls /var/lib/pgsql/data nothing
Previous:From: Devrim GÜNDÜZDate: 2011-03-31 11:39:51
Subject: Re: ls /var/lib/pgsql/data nothing

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group