On 03/11/2013 10:46 AM, Tom Lane wrote:
Steve Erickson <[email protected]> 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
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
