Postgres Pro
Downloads
Home   >   mailing lists

Re: "Could not open relation XXX: No such file or directory" - Mailing list pgsql-general

From Craig Ringer
Subject Re: "Could not open relation XXX: No such file or directory"
Date
Msg-id 4A8BD63C.6030602@postnewspapers.com.au
Whole thread Raw
In response to "Could not open relation XXX: No such file or directory"  (Alan Millington <admillington@yahoo.co.uk>)
Responses Re: "Could not open relation XXX: No such file or directory"  (Yaroslav Tykhiy <yar@barnet.com.au>)
List pgsql-general
Tree view 
On 19/08/2009 6:26 PM, Alan Millington wrote:

> 2009-08-19 03:06:45 ERROR: could not read block 0 of relation
> 1663/52752/52896: No such file or directory

> Clearly something is amiss, but I don't know what. I should be grateful
> for any suggestions as to what I should check.

Got a virus scanner installed? If so, remove it (do not just disable it)
and see if you can reproduce the problem. Ditto anti-spyware software.

You should also `chkdsk' your file system(s) and use a SMART diagnostic
tool to test your hard disk (assuming it's a single ATA disk).

--
Craig Ringer

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: A history procedure that prevents duplicate entries
Next
From: "Andrus Moor"
Date:
Subject: Re: index "pg_authid_rolname_index" is not a btree