| From: | Ralph Smith <smithrn(at)u(dot)washington(dot)edu> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | ERROR: Could not access status of transaction #### |
| Date: | 2007-10-19 20:04:09 |
| Message-ID: | 3C42CC69-389A-4F09-8FFD-87C4F520C866@u.washington.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I'm using 7.4 in preparation for an overdue upgrade.
Yesterday I posted 2 questions that were ignored, so I'll try a third
now.
When doing a query I get same error as below, which are the results
of vacuumdb.
vacuumdb: vacuuming of database "airburst" failed: ERROR: could not
access status of transaction 7564911
DETAIL: could not open file "/var/lib/postgresql/7.4/main/pg_clog/
0007": No such file or directory
I'm only querying from 1 table.
I could really use some help.
----
Regarding yesterday's Qs, how best to un-import from pg_dumpall's
results?
I'd dump-all'd into a text file and imported it via a psql -f filename.
It had encoding errors AND did NOT make the database I needed.
Everything went into db postgres.
Please help.
Ralph Smith
smithrn(at)u(dot)washington(dot)edu
=====================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2007-10-19 20:29:37 | Re: Abbreviation list |
| Previous Message | Erik Jones | 2007-10-19 19:53:05 | Re: Abbreviation list |