Re: [7.4.1] signal 11 while accesing DB

Marcin <migor(at)op(dot)pl> writes:
> Okay, then pg_filedump 1262:

> and suddenly:
> Block 4 ********************************************************
> <Header> -----
> Block Offset: 0x00008000 Offsets: Lower 0 (0x0000)
> Block: Size 0 Version 0 Upper 0 (0x0000)
> LSN: logid 0 recoff 0x00000000 Special 0 (0x0000)
> Items: 0 Free Space: 0
> Length (including item array): 24

> Error: Invalid header information.

Ah-hah. This case should be coped with by 7.4.3 and later, due to this patch:

2004-06-05 13:42 tgl

* src/include/storage/: bufpage.h (REL7_4_STABLE), bufpage.h:
Adjust PageGetMaxOffsetNumber to ensure sane behavior on
uninitialized pages, even when the macro's result is stored into an
unsigned variable.

In the meantime a VACUUM of pg_database should get you out of trouble.

regards, tom lane