Re: Pgdump error "invalid page header in block"

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: tuanhoanganh <hatuan05(at)gmail(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Pgdump error "invalid page header in block"
Date: 2011-03-04 11:56:34
Message-ID: 9B7F0A28-8552-4280-BB39-6C35627E56F3@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Mar 4, 2011, at 1:17 PM, tuanhoanganh wrote:

> pg_dump: reading dependency data
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: invalid page header in block 299 of relation "pg_depend_depender_index"
> pg_dump: The command was: SELECT classid, objid, refclassid, refobjid, deptype FROM pg_depend WHERE deptype != 'p' ORDER BY 1,2
> pg_dump: *** aborted because of error

reindexdb -s <database name>

will resolve the issue.

Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Buckler 2011-03-04 14:02:10 How to select a list of sequences?
Previous Message Vibhor Kumar 2011-03-04 11:54:04 Re: updating all records of a table