Re: Upgrading postgresql-8.4

Steve Erickson <serickson@digitiliti.com> writes:
> Thanks for the reply.  I deleted all rows in pg_statistic and the VACUUM ANALYZE on pg_attribute still fails.

You would probably need to actually truncate pg_statistic (in a
standalone backend) to make that safe.  If you only want to use DELETE,
I'd try just pg_dump at this point rather than trying to make the
database fully usable again.

> I tried to reindex pg_toast_2619 and got an error "could not access status of transaction 1493786085.  Could not open
file"pg_subtrans/5909": No such file or directory.  Sure enough, there is no such file - only 5905.   

This suggests that your problems are larger than you've indicated so
far.  What happened to this machine anyway?

            regards, tom lane