Skip site navigation (1) Skip section navigation (2)

block error, but can't pg_dump

From: NOW Web Sites Manager <webperson(at)now(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: block error, but can't pg_dump
Date: 2008-06-13 16:41:20
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
I have a table that reports one block error when I try to select 
everything, reindex, vacuum, etc. (invalid page header in block 
413620 of relation "tablename")  I've read on the list that the thing 
to do is use pg_dump and then restore it.  However, pg_dump fails 
with the same error.

I can't take down the whole server, let alone easily Postgresql, to 
debug this.  Any ideas as to how I could do this?  I wrote a Perl 
script to select the records one by one but it didn't find a bad 
record although maybe it's how I wrote the script (it just selected 
the records one by one.)

I also don't know enough about Postgresql data/blocks to figure out 
which data is in that block and what I'd do with that.

Thanks in advance.  P.S. "relation" means the table, not an index, 
right?  I don't see an index with the same name as the table, but 
thought I'd check.


pgsql-admin by date

Next:From: Tom LaneDate: 2008-06-13 19:44:46
Subject: Re: block error, but can't pg_dump
Previous:From: Rafael DomicianoDate: 2008-06-13 16:06:31
Subject: Re: Revoke for a new role

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group