table corruption

From: "Thilo Hille" <thilo(at)resourcery(dot)de>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: table corruption
Date: 2003-05-20 10:34:06
Message-ID: 001a01c31ebb$5714bb80$0b00a8c0@resourcery.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,
i am using postgresql-7.2.3. One of the tables in my database seems to be
corrupted.
It has about 250000 records, but when dumping the table postmaster crashes
when querys exceeding row 152238.

"select * from prvlog limit 1,152238;" works fine

"select * from prvlog limit 1,152239;" results in:
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: Succeeded.

The same happens to anything above 152239. (well, i didnt tried all...)
The first (regarding to the tabledefinition) 2 fields of row 152239 can be
viewed. Querying other rows show the above error.
There is no index on the table. Is there something i can do to rescue the
data?

Regards
Thilo

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Nabil Sayegh 2003-05-20 12:49:26 Re: SELECT across multiple db
Previous Message Dave Page 2003-05-20 07:08:20 Re: ENCODING (Unicode)