Re: Missing pg_clog files

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Missing pg_clog files
Дата
Msg-id 4913.1222271062@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Missing pg_clog files  (Carol Walter <walterc@indiana.edu>)
Ответы Re: Missing pg_clog files  (Carol Walter <walterc@indiana.edu>)
Список pgsql-admin
Carol Walter <walterc@indiana.edu> writes:
> Are the files that contain the hex characters supposed to contain a
> single string and no control characters?

Yes, you want 256K occurrences of the byte value 0x55 and nothing else.

> I'm also wondering if, after I create the dummy files, and pg_dump
> works, I could restore an old pg_dumpall file and then insert any
> data that aren't there from the pg_dumps.

It'd be a good idea to do as much cross-checking as you can, since
it's highly probable that the dumped data will be at least partly wrong.

No, I'm afraid updating to 8.2.latest won't get you out of this.
It might possibly prevent a recurrence.

            regards, tom lane

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

Предыдущее
От: Carol Walter
Дата:
Сообщение: Re: Missing pg_clog files
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Missing pg_clog files