Re: Serious Crash last Friday

"Henrik Steffen" <steffen@city-map.de> writes:
> I now did a "pg_filedump -R 1048595 16584" on the file
> /var/lib/pgsql/data/base/16556/16584

What file is that?  Doesn't look like it is an index ...

> It delivered the following output. Can you read anything from it?

Not a lot.  I'd suggest "pg_filedump -i FILENAME" where FILENAME is the
OID of the toast-table index for your problem table.  (Look at
pg_class.reltoastidxid if you're not sure.)  That should produce a ton
of output along the lines of

 Item 155 -- Length:   12  Offset: 4720 (0x1270)  Flags: USED
  Block Id: 4  linp Index: 39  Size: 12
  Has Nulls: 0   Has Varlenas: 0

What you want to look for is outrageously large values in the "Block Id"
field.  Once you find 'em, a "pg_filedump -i -f" of just the block
containing the broken item(s) would be worth studying.

            regards, tom lane