table corruption
| От | Thilo Hille |
|---|---|
| Тема | table corruption |
| Дата | |
| Msg-id | 001a01c31ebb$5714bb80$0b00a8c0@resourcery.de обсуждение исходный текст |
| Ответ на | Tables and functions and triggers oh my... ("Fontenot, Paul" <Paul.Fontenot@bannerhealth.com>) |
| Ответы |
Re: table corruption
Re: table corruption |
| Список | 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
В списке pgsql-novice по дате отправления: