Thread: Corruption... please help

Corruption... please help

From
"Ed"
Date:
Hi...

I am unable to select every row from a table.  Every time, the backend
disconnect.  When I do a :

The_DB=> vacuum;

I get :

ERROR:  Invalid XID in t_cmin (2)

What does it meens and how can I recover from it?


Frédéric Boucher
Ed@jetumele.com




Re: Corruption... please help

From
Bruce Momjian
Date:
[ Charset ISO-8859-1 unsupported, converting... ]
> Hi...
> 
> I am unable to select every row from a table.  Every time, the backend
> disconnect.  When I do a :
> 
> The_DB=> vacuum;
> 
> I get :
> 
> ERROR:  Invalid XID in t_cmin (2)
> 
> What does it meens and how can I recover from it?
> 

Are you the one moving the table files around?  You need pg_log.  See
pg_upgrade.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026