Re: Postgres crashes,help to recover

From: "Andrus" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres crashes,help to recover
Date: 2005-07-20 09:20:20
Message-ID: dbl510$niu$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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"

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josef Springer 2005-07-20 09:28:23 Creating a database with psql
Previous Message Andrus 2005-07-20 09:04:54 Re: Postgres crashes,help to recover