Database Corruption??

From: Joe Cleave <joe(dot)cleave(at)framestore(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Cc: joe(dot)cleave(at)framestore(dot)co(dot)uk
Subject: Database Corruption??
Date: 1999-01-08 16:08:26
Message-ID: 36962D79.FA86DF41@framestore.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Can anyone help? My pgsql problem manifests itself as follows.......

1) After psql'ing into a database, there is a table which has 3 fields
which cannot be selected from, instead
the following error occurs:

e.g. select fieldname from mytable;

FATAL: unrecognized data from the backend. It probably dumped core.
FATAL: unrecognized data from the backend. It probably dumped core.

Then I have to \q and go back in.

The same happens when selecting * from mytable;

You can do a \d to get the table description, and all other tables seem
to be ok.

2) On doing a pg_dump of this database, the following error occors:

e.g. pg_dump -o dbase > dumpfile

resetting connection
SQL query to dump the contents of Table mytable did not execute
correctly. After we read all the table contents from the backend,
PQendcopy() failed. Explanation from backend: 'Error return detected
from backend, but attempt to read the message failed.'.
The query was: 'COPY mytable WITH OIDS TO stdout;
'.

Does anyone know how to rescue my data??
Are there any corresponding bugs with PostgreSql??
Is there any diags stuff to help??
How can I determine exactly what bit of the table is corrupt??
The select version(); does not work either.

any answers??

cheers
Joe.

--
Joe Cleave, FrameStore Ltd
joe(dot)cleave(at)framestore(dot)co(dot)uk

Browse pgsql-admin by date

  From Date Subject
Next Message Shane Wilson 1999-01-09 03:59:50 MSaccess97 instert & memo
Previous Message Javier Cajal 1999-01-08 11:22:18 Information about COPYRIGHT