Hi there,
On 19/08/2009, at 8:38 PM, Craig Ringer wrote:
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).
By the way, `chkdsk' in Windows or `fsck' in Unix can, in a way, be a
_source_ of file loss if the file metadata got damaged badly, e.g., by
a system crash, and the file node has to be cleared. So I've always
been curious if there is a way to retrieve surviving records from a
PostgreSQL database damaged by file loss. Do you know any? (Of
course, the only true solution is to have been making backups
beforehand, but...)
Thanks!
Yar
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
