Re: unable to repair table: missing chunk number

When faced with a similiar sounding problem I tried the following with
some success.  It is an extreme alternative and not suited to all
situations...that having been said, here goes.

pg_dump mytable >> mytable.txt

You said
 > When I dump the table to disk I get records in sequence by primary key
 > from 1 to 115847 before it crashes.

I looked at the mytable.txt file and found the last entry that pg_dump
was able to copy and noted the primary key number (115847).

I then executed a quiery that deleted the very next primary key number
(115848) record.  (*BAD!  Lost that data record.  BAD!*)

I was then able to do a pg_dump of the entire table followed by a
vacuum/analyze.  (*Good.  PG is running correctly. Good*)

In my singular case the loss of one data record is acceptable.  It may
not be for you.  Try this resolve only at your own risk and peril.

Peace

- Bill