ERROR: Could not access status of transaction ####

Поиск
Список
Период
Сортировка
От Ralph Smith
Тема ERROR: Could not access status of transaction ####
Дата
Msg-id 3C42CC69-389A-4F09-8FFD-87C4F520C866@u.washington.edu
обсуждение исходный текст
Ответы Re: ERROR: Could not access status of transaction ####  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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
=====================


В списке pgsql-general по дате отправления:

Предыдущее
От: Erik Jones
Дата:
Сообщение: Re: Abbreviation list
Следующее
От: Stephane Bortzmeyer
Дата:
Сообщение: Re: running postgres