Re: BUG #4383: operations in a certain row makes server process terminate with signal 11

From: "Marco Aurelio Miranda" <macmiranda(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4383: operations in a certain row makes server process terminate with signal 11
Date: 2008-08-29 01:05:19
Message-ID: a957cd420808281805t59c18baerd5afe93f1c0b2d62@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

>
>
> That part sounds more like the table row is corrupted :-(. If you
> aren't in a position to restore the whole table from backup, you'll
> need to try to identify and wipe out the broken row. Usually zeroing
> its whole page is the easiest way to do this, though you'll want to
> see what else is on that page first. Check the PG archives for
> discussions of recovering from corrupted-data scenarios.
>
> regards, tom lane
>
Tom,

how do I erase just one block of the table file?

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PoolSnoopy 2008-08-29 01:19:09 Re: libpq does not manage SSL callbacks properly when other libraries are involved.
Previous Message Tom Lane 2008-08-28 14:41:54 Re: BUG #4383: operations in a certain row makes server process terminate with signal 11