Re: [7.4.1] signal 11 while accesing DB

Marcin <migor@op.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