Re: Please help with this error message - Mailing list pgsql-general

From Chris Smith
Subject Re: Please help with this error message
Date
Msg-id 033801c2f3dd$91dac1f0$6700000a@KYA
Whole thread Raw
In response to Please help with this error message  ("Chris Smith" <cdsmith@twu.net>)
Responses Re: Please help with this error message
List pgsql-general
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


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: transaction blocking inserts in postgresql 7.3
Next
From: Andrew Sullivan
Date:
Subject: Re: Please help with this error message