pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tony Da Silva <tony@altonet.co.za>
To: pgsql-admin@postgresql.org
Subject: problem with pg_statistic_relid_att_index
Date: Mon, 10 Mar 2008 14:57:23 +0200
Message-ID: <20080310125732.332572E014D@postgresql.org> (raw)

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






view thread (2+ messages)  latest in thread

Message-ID: <20080310125732.332572E014D@postgresql.org>
Permalink:  ../20080310125732.332572E014D@postgresql.org/
Also on:    postgresql.org/message-id/20080310125732.332572E014D@postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tony@altonet.co.za
  Subject: Re: problem with pg_statistic_relid_att_index
  In-Reply-To: <20080310125732.332572E014D@postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox