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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-06-09 23:01:38 | now 6.4 |
Previous Message | Brandon Ibach | 1998-06-09 21:13:12 | Re: [HACKERS] Table corrupt? |