Re: Serious Crash last Friday

"Henrik Steffen" <steffen(at)city-map(dot)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