error connecting to database: could not open relation

Поиск
Список
Период
Сортировка
От PontoSI - Consultoria, Informática e Serviços LDA
Тема error connecting to database: could not open relation
Дата
Msg-id 48101014.2040708@pontosi.pt
обсуждение исходный текст
Ответы Re: error connecting to database: could not open relation
Re: error connecting to database: could not open relation
Список pgsql-general
Hi,
I've had a server crash on a machine running FreeBSD 6 and PG 8.2.5. The
database was running at the time of the crash, and probably there was
some lost data. When I try to start PG in single mode (and width -P) he
complains that he "could not open relation with OID 2661". Because the
file is missing, I've tried to create a zeroed file with the size of a
page too see if we would eat it so I can dump the data, but without
success. I've also tried pgfsck without any luck.
Is there any way to get around the missing files and dump directly the
values stored inside the actual table files?

Regards,
    João Pinheiro

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: initdb in 8.3
Следующее
От: xaviergxf
Дата:
Сообщение: Table with differerent Data Types