Postgres Pro
Downloads
Home   >   mailing lists

Re: Pgdump error "invalid page header in block" - Mailing list pgsql-general

From Vibhor Kumar
Subject Re: Pgdump error "invalid page header in block"
Date
Msg-id 9B7F0A28-8552-4280-BB39-6C35627E56F3@enterprisedb.com
Whole thread Raw
In response to Pgdump error "invalid page header in block"  (tuanhoanganh <hatuan05@gmail.com>)
List pgsql-general
Tree view 
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'
ORDERBY 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.kumar@enterprisedb.com
Blog:http://vibhork.blogspot.com

pgsql-general by date:

Previous
From: Vibhor Kumar
Date:
Subject: Re: updating all records of a table
Next
From: Kenneth Buckler
Date:
Subject: How to select a list of sequences?