I would provide all the needed information if I only had them. The
thing is it happened on one of our client's machine and all he did was
reporting the problem without providing us the data folder. So I asked
the question just to know whether it is possible to read from a higher
block number than the highest physical number. Thank You for Your
2010/9/28 Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>:
> Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> wrote:
>> I got an error "Could not read block <no.> of relation...." it
>> appeared to be in pg_trigger
> If you'd pasted in the message as it appeared, we wouldn't need to
> guess whether you're right.
>> the block number was 110 and the file has only 67 pages. So the
>> question is how is it possible?
> That could be, if your reading of things is right, database
> corruption. Before you do anything else, shutdown the database
> server and make a copy of the data directory and all its
> subdirectories. (Don't try to pick one database or otherwise pick
> and choose files.) Save that backup until you've recovered from the
> problem and things have been stable for at least a few weeks.
> Next, read this page and repost with more information:
> So far you haven't given us much to work with.
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
II MU Bioinformatyka
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2010-09-28 14:40:29|
|Subject: Re: Could not read block error question |
|Previous:||From: Kevin Grittner||Date: 2010-09-28 14:03:09|
|Subject: Re: Could not read block error question|