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.

  • 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 '14 at 11:50
  • Also, what's the exact PostgreSQL version? 9.2.[what] ? – Craig Ringer May 15 '14 at 11:53
  • See also dba.stackexchange.com/q/59948/7788 – Craig Ringer May 15 '14 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 '14 at 11:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.