Re: ERROR: invalid page header in block 502758 of relation base/16388/16403 - Mailing list pgsql-bugs

From fous velkej
Subject Re: ERROR: invalid page header in block 502758 of relation base/16388/16403
Date
Msg-id 27cffc0909170722r3333533crdca2a38efa86f84f@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: invalid page header in block 502758 of relation base/16388/16403  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
there is a database running on xen dom U, but the node (dom0) went down,
we have a cluster, so the other node started the service and there is
nothing that shows any problem
unless i use SELECT on this database/table (this db contains only one table)
there is no backup of the database.
i can't see any solution and if you can't see any solution either, i'm
going to reinit the db
:)

fous

2009/9/17 Tom Lane <tgl@sss.pgh.pa.us>:
> fous velkej <honza801@gmail.com> writes:
>> ok, so i did reindexing ending with following error
>> proxylog=3D# REINDEX TABLE user_record ;
>> ERROR: =A0concurrent insert in progress
>
> So that page header wasn't the only corrupted data in your database.
> Maybe you'd better take a step back and tell us some context about
> your problem. =A0I hope you've got recent backups, because if there's
> two different corrupted spots there are probably a lot more.
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0regards, tom lane
>

pgsql-bugs by date:

Previous
From: "philip wright"
Date:
Subject: BUG #5062: 8.4.1 compile fails on debian can't find libdl
Next
From: Tom Lane
Date:
Subject: Re: BUG #5062: 8.4.1 compile fails on debian can't find libdl