Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres crashes,help to recover - Mailing list pgsql-general

From Andrus
Subject Re: Postgres crashes,help to recover
Date
Msg-id dbl510$niu$1@news.hub.org
Whole thread Raw
In response to Postgres crashes,help to recover  ("Andrus" <eetasoft@online.ee>)
List pgsql-general
Tree view 
It seems that corrupted table klient contains data from some other table.

select * from firma1.klient limit 3686;

Seems to return all data from table.
Starting at row 3687  table contains data from other table.

VACUUM command returns:

INFO:  vacuuming "firma1.klient"

ERROR:  invalid page header in block 1639 of relation "klient"

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Postgres crashes,help to recover
Next
From: Josef Springer
Date:
Subject: Creating a database with psql