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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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: . 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 – Craig Ringer May 15 '14 at 11:55
Huh.... are you the same person as ? 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 posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.