On Friday 20 Jun 2003 7:22 pm, Johnson, Shaunn wrote:
> --howdy:
>
> --this is what i was talking about when doing
> --things like 'vacuum' and 'pg_dump'.
[snip]
> Backing up schema for debborah_dev_bh_claimsum_4q02 ...
> pg_dump: query to obtain list of indexes failed: ERROR: syscache lookup
> for index 4185182890 failed
As Tom said, if you're on 7.2.1, upgrade to 7.2.4 immediately. Stop PG and
take a backup of the entire data/base directory tree, Being paranoid, I'd set
it up in parallel on a separaate machine or with a different PGDATA (and port
etc). Then see if pg_dump for 7.2.4 can cope. There were a number of bugfixes
between 7.2.1 and .4 - details in the release notes.
--
Richard Huxton