Re: URGENT: pg_statistic_relid_att_index has gone

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Harald Lau <harald(at)sector-x(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: URGENT: pg_statistic_relid_att_index has gone
Date: 2005-10-03 14:08:14
Message-ID: 21820.1128348494@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Harald Lau <harald(at)sector-x(dot)de> writes:
> on a 7.2 System (Suse-Linux) I got an error "duplicate key in unique
> index pg_statistic_relid_att_index" (think it was while vacuuming)
> I REINDEXd the database.
> Now the table pg_statistic_relid_att_index is completely gone.
> Has anybody an advise?

Dump, initdb, reload. You've probably got more problems than just
that. This might be a good time to update to something newer than
PG 7.2, too.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message jan.aerts@bbsrc.ac.uk 2005-10-03 15:14:11 index on custom function; explain
Previous Message Harald Lau 2005-10-03 14:01:02 Re: URGENT: pg_statistic_relid_att_index has gone