Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database
Дата
Msg-id 4286.1019759001@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database  (Michael Glenn <mike@mglenn.com>)
Список pgsql-admin
Michael Glenn <mike@mglenn.com> writes:
> I downloaded pg_dumpfile (thank you) then eventually found out I need to
> download, configure, and point to 7.2.1 source to compile, which makes
> sense now.
> I compiled and attempted a dump with the references and without the
> references to LSN from the function FormatHeader. In both cases I
> received the dump output below indicating  "Invalid header
> information.". Now, is each block header corrupted OR is the dump
> utility not able to read older pg_database files?

If you compiled the pg_dumpfile sources using 7.2 header files, then
they'd be using the 7.2 page header struct, which is the wrong thing.
You need to use the 7.0 version of the PageHeaderData struct
(see src/include/storage/bufpage.h).

My inclination would be to try to compile pg_dumpfile against the 7.0
headers not 7.2.  You might have to rip out references to pg_control and
CRC checking to make that work, but there are no CRCs in 7.0 files
anyway so you won't lose any functionality.  Once it does compile you
could be pretty sure that it would actually work.

            regards, tom lane

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

Предыдущее
От: Michael Glenn
Дата:
Сообщение: Re: Database 'xxxx', OID yyyyy, has disappeared from pg_database
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_restore and permissions