Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B46722E014F for ; Mon, 10 Mar 2008 09:57:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 94378-06 for ; Mon, 10 Mar 2008 09:57:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.altonet.co.za (mail.altonet.co.za [216.236.177.11]) by postgresql.org (Postfix) with SMTP id 332572E014D for ; Mon, 10 Mar 2008 09:57:29 -0300 (ADT) Received: (qmail 18358 invoked by uid 399); 10 Mar 2008 12:57:23 -0000 Received: from unknown (HELO tonyds) (tony@idws.com@216.236.177.101) by mail.altonet.co.za with SMTP; 10 Mar 2008 12:57:23 -0000 X-Originating-IP: 216.236.177.101 Reply-To: From: "Tony Da Silva" To: Subject: problem with pg_statistic_relid_att_index Date: Mon, 10 Mar 2008 14:57:23 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook, Build 11.0.5510 Thread-Index: AciCrkjFU6txGrfxQHaVyTp1YqEiLQ== X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1914 Message-Id: <20080310125732.332572E014D@postgresql.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.198 tagged_above=0 required=5 tests=AWL=1.198 X-Spam-Level: * X-Archive-Number: 200803/75 X-Sequence-Number: 28558 Hi, I seem to have a problem on one of my databases, When I log into pgsql I see this: ERROR: Invalid page header in block 3 of pg_statistic_relid_att_index Welcome to psql 7.3.4, the PostgreSQL interactive terminal. When I try to run any command (eg vacuum) I get this message: dbname=> vacuum full; ERROR: current transaction is aborted, queries ignored until end of transaction block reindex also does not work: dbname=> reindex index pg_statistic_relid_att_index; ERROR: current transaction is aborted, queries ignored until end of transaction block Please can somebody help if you know how to fix this. Thx Tony