Steve Erickson <serickson@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
