Re: [HACKERS] Table corrupt?

>
> Bruce Momjian said:
> >
> > >    Any ideas on what might be going on here?  And, if postgres won't
> > > be able to access the table, is there any hope of extracting rows from
> > > the raw database file, such that I could reconstruct the table?
> >
> > pg_dump -t tablename, drop and reload?
> >
>    I thought pg_dump got the data out via queries through the backend?
> (But, then, I could be wrong... please correct me if so...)
>
> -Brandon :)
>

I gets the data out via COPY, which is slightly different than a normal
query that does through the parser/optimizer/executor.  It is possible
you just have a lot of extra data and it is taking time to vacuum.

If there is a real problem, I would dump the entire database and reload
it.

--
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)