Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

While taking a backup from my PostgrSQL database, it is showing this:

pg_dump: Dumping the contents of table "gtab17" failed: PQgetResult() failed.
pg_dump: Error message from server: ERROR:  invalid page header in block 9576 of relation     base/17779/758869
pg_dump: The command was: COPY public.gtab17 (jrdetid, jrmid, acid, dr, cr, narr, ageamt) TO stdout;

I think my table gtab17 is corrupt. I tried:

  • Vaccum Full error on this table

INFO: vacuuming "public.gtab17" ; ERROR: row is too big: size 3256104, maximum size 8160

  • Analyze error

INFO: analyzing "public.gtab17" ;
ERROR: invalid page header in block 9576 of relation base/17779/758869

Database: PostgreSQL 9.2
OS: Windows XP SP3
Filesystem: NTFS

I have googled but dint get any solution to solve this.

share|improve this question
    
Before you do anything else, immediately read and follow these instructions: wiki.postgresql.org/wiki/Corruption . Once you have done that, please explain a bit more. Any recent operating system / hardware errors or crashes? Any unexpected restarts? What's the disk storage - SSD, single hard drive, RAID, ... ? If SSD, what model? Is there antivirus software installed and if so, what is it? –  Craig Ringer May 15 at 11:50
    
Also, what's the exact PostgreSQL version? 9.2.[what] ? –  Craig Ringer May 15 at 11:53
    
See also dba.stackexchange.com/q/59948/7788 –  Craig Ringer May 15 at 11:55
    
Huh.... are you the same person as stackoverflow.com/q/23670534/398670 ? If so, don't post the same question on multiple sites please, especially without linking between them. –  Craig Ringer May 15 at 11:56

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.