Received: from candle.pha.pa.us (pgman@nav-43.dsl.navpoint.com [162.33.245.46]) by hub.org (8.10.1/8.10.1) with ESMTP id e6ADS2W73203 for ; Mon, 10 Jul 2000 09:28:02 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id JAA26977; Mon, 10 Jul 2000 09:27:29 -0400 (EDT) From: Bruce Momjian Message-Id: <200007101327.JAA26977@candle.pha.pa.us> Subject: Re: Corruption... please help In-Reply-To: <008d01bfea71$5fbd2aa0$b48c29d1@citenet.net> "from Ed at Jul 10, 2000 09:18:44 am" To: Ed Date: Mon, 10 Jul 2000 09:27:29 -0400 (EDT) CC: pgsql sql X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200007/97 [ 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, Pennsylvania 19026