Re: Corruption... please help - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Corruption... please help
Date
Msg-id 200007101327.JAA26977@candle.pha.pa.us
Whole thread Raw
In response to Corruption... please help  ("Ed" <ed@jetumele.com>)
List pgsql-sql
[ 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
 


pgsql-sql by date:

Previous
From: "Ed"
Date:
Subject: Corruption... please help
Next
From: Thomas Lockhart
Date:
Subject: Re: Type conversion