Re: "Could not open relation XXX: No such file or directory"

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: "Could not open relation XXX: No such file or directory"
Date: 2009-08-19 10:38:52
Message-ID: 4A8BD63C.6030602@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus Moor 2009-08-19 12:33:43 Re: index "pg_authid_rolname_index" is not a btree
Previous Message Alban Hertroys 2009-08-19 10:29:46 Re: A history procedure that prevents duplicate entries