Re: [HACKERS] Table corrupt? - Mailing list pgsql-hackers

From Brandon Ibach
Subject Re: [HACKERS] Table corrupt?
Date
Msg-id 199806100159.UAA23884@vweb.infomansol.com
Whole thread Raw
List pgsql-hackers
Vadim Mikheev said:
>
> Brandon Ibach wrote:
> >
> > Vadim Mikheev said:
> >    Okay... using pg_dump to get the data out of the table is causing
> > much the same situation.  I did a backtrace in gdb, but unfortnately,
> > I'm running a copy of postgres without debugging symbols, so it may be
> > of limited use.  Here 'tis...
> >
> > #0  0x80b7590 in WaitIO ()
>
> Did you restart postmaster after killing backend (vacuum) ?
>
> Vadim
>
   Nope... :)  And I just thought of that possibility while sifting
through the buffer manager code (and meantime, your email arrived).
Thanks for the tip, I bet it will work.

-Brandon :)

pgsql-hackers by date:

Previous
From: Brandon Ibach
Date:
Subject: Re: [HACKERS] Table corrupt?
Next
From: Bruce Momjian
Date:
Subject: Re: [PATCHES] Try again: S_LOCK reduced contention