Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Table corrupt?

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: bibach(at)infomansol(dot)com (Brandon Ibach)
Cc: hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Table corrupt?
Date: 1998-06-09 21:16:41
Message-ID: 199806092116.RAA05041@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
> 
> 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(at)candle(dot)pha(dot)pa(dot)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)

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 1998-06-09 23:01:38
Subject: now 6.4
Previous:From: Brandon IbachDate: 1998-06-09 21:13:12
Subject: Re: [HACKERS] Table corrupt?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group