Okay,
After the suggestion of possible hardware problems, we've decided to move
the database to yet another server in the hopes that this will cause the
problem to go away. Trouble is, we've still a corrupted record. I
successfully deleted one of the corrupted records; the other, when I attempt
to delete it, responds with:
PANIC: open of /data/dac/pg_clog/09C5 failed: No such file or directory
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
I then get a psql prompt of "!>", and am no longer connected to the
database. Any suggestions on how to delete this record? Does this mean
that the data is corrupted more than I think?
--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.
Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation