"tech techie" <techie@1stcounsel.com> writes:
> After the most recent 'crash' I went into
> single user mode, and did the following:
> 1) reindex database dbname --> 5 minutes to run
> 2) vacuum full ----> 45 minutes with the
> following errors:
> backend> vacuum full;
> WARNING: Index
> pg_attribute_relid_attnam_index: NUMBER OF
> INDEX' TUPLES (1191) IS NOT THE SAME AS HEAP'
> (1302).
> Recreate the index.
> [ etc ]
Whoa. If you are seeing that immediately after a reindex, then there's
something really wrong. Have you done any hardware diagnostics
recently? memtest86 and badblocks seem to be the standard tools to try.
regards, tom lane