| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve Erickson <serickson(at)digitiliti(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Upgrading postgresql-8.4 |
| Date: | 2013-03-11 17:46:58 |
| Message-ID: | 21069.1363024018@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Sievers | 2013-03-11 18:07:45 | Re: restoring to different architecture with WAL |
| Previous Message | Steve Erickson | 2013-03-11 17:39:00 | Re: Upgrading postgresql-8.4 |