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 attention.
2010/9/28 Kevin Grittner <[email protected]>: > Lukasz Brodziak <[email protected]> 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: > > http://wiki.postgresql.org/wiki/Guide_to_reporting_problems > > So far you haven't given us much to work with. > > -Kevin > > -- > Sent via pgsql-admin mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- Łukasz Brodziak II MU Bioinformatyka -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
