Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id CB126632CCD for ; Tue, 10 Feb 2009 03:57:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 23252-10 for ; Tue, 10 Feb 2009 03:57:51 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mk-filter-4-a-1.mail.uk.tiscali.com (mk-filter-4-a-1.mail.uk.tiscali.com [212.74.100.55]) by mail.postgresql.org (Postfix) with ESMTP id 74A37632C72 for ; Tue, 10 Feb 2009 03:57:51 -0400 (AST) X-Trace: 142580349/mk-filter-4.mail.uk.tiscali.com/B2C/$b2c-THROTTLED-DYNAMIC/b2c-CUSTOMER-DYNAMIC-IP/80.225.14.181/None/john.lister-ps@kickstone.com X-SBRS: None X-RemoteIP: 80.225.14.181 X-IP-MAIL-FROM: john.lister-ps@kickstone.com X-MUA: Thunderbird 2.0.0.19 (Windows/20081209) X-IP-BHB: Once X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AkwBAJPCkElQ4Q61/2dsb2JhbAAI0hWEGgY X-IronPort-AV: E=Sophos;i="4.38,185,1233532800"; d="scan'208";a="142580349" Received: from 80-225-14-181.dynamic.dial.as9105.com (HELO [192.168.6.11]) ([80.225.14.181]) by smtp.tiscali.co.uk with ESMTP; 10 Feb 2009 07:57:49 +0000 Message-ID: <4991338B.704@kickstone.com> Date: Tue, 10 Feb 2009 07:58:03 +0000 From: John Lister User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: database corruption help References: <507152DDF8AB4DF093BD01A8BEC7C659@squarepi.com> <17205.1234200693@sss.pgh.pa.us> <4990840C.4090900@kickstone.com> <20151.1234208044@sss.pgh.pa.us> <49908D72.7040904@kickstone.com> <25753.1234224090@sss.pgh.pa.us> In-Reply-To: <25753.1234224090@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/69 X-Sequence-Number: 31290 Sorry, had exported it - bad cut/pasting... I even tried it in single-user mode passing -P directly but got the same result Also confused/concerned by the 7 dead rows in pg_class. as i've restarted the server all transaction should have finished so i'd like to reclaim these - especially as vacuum reports the table is using 80Mb+ Thanks >> still getting the same problem. >> > > >>>> PGOPTIONS="-P" >>>> psql backend >>>> > > I think you need export PGOPTIONS="-P" to make that work. Whether > it's related to your problem isn't clear though. > > regards, tom lane >