From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Lukasz Brodziak <lukasz.brodziak@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Could not read block error question
Date: Tue, 28 Sep 2010 09:03:09 -0500
Message-ID: <4CA1AF4D0200002500035FF5@gw.wicourts.gov> (raw)
In-Reply-To: <AANLkTimp=VKdRmF+7iu4o4oBLYoyTzVSEsCWdv+noWih@mail.gmail.com>
References: <AANLkTimp=VKdRmF+7iu4o4oBLYoyTzVSEsCWdv+noWih@mail.gmail.com>
Lukasz Brodziak <lukasz.brodziak@gmail.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:
http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
So far you haven't given us much to work with.
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, lukasz.brodziak@gmail.com
Subject: Re: Could not read block error question
In-Reply-To: <4CA1AF4D0200002500035FF5@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox