Re: Upgrading postgresql-8.4

On 03/11/2013 10:46 AM, Tom Lane wrote:
> Steve Erickson <serickson(at)digitiliti(dot)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?

Possibly being bit by this?:

http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
>
> regards, tom lane
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com