problem with pg_statistic_relid_att_index - Mailing list pgsql-admin

From Tony Da Silva
Subject problem with pg_statistic_relid_att_index
Date
Msg-id 20080310125732.332572E014D@postgresql.org
Whole thread Raw
Responses Re: problem with pg_statistic_relid_att_index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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




pgsql-admin by date:

Previous
From: Shilpa
Date:
Subject: Re: Time Zone in Postgres
Next
From: "Mark Steben"
Date:
Subject: Newly converted to 8.2.5 and getting this error