| From: | tpdasilva(at)gmail(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | problem with pg_statistic_relid_att_index |
| Date: | 2008-03-10 12:30:11 |
| Message-ID: | f02ee2c9-4072-4d8d-8ebc-13b1c8fcd8ee@b1g2000hsg.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2008-03-10 12:34:43 | Re: loading a psql input file on win xp |
| Previous Message | Alvaro Herrera | 2008-03-10 12:25:52 | Re: v8.3 + UTF8 errors when restoring DB |