Re: recovering a control file from a shutdown database....

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: recovering a control file from a shutdown database....
Дата
Msg-id 29318.999746140@sss.pgh.pa.us
обсуждение исходный текст
Ответ на recovering a control file from a shutdown database....  (Jerry Asher <jerry@theashergroup.com>)
Список pgsql-general
Jerry Asher <jerry@theashergroup.com> writes:
> Can anything be done to recover the pg_control file?

I've already been talking to Jerry off-list, and I trust he's managed
to recover his data --- but for the archives, the answer to this is to
hack up contrib/pg_resetxlog to force whatever data you need into the
pg_control file.

It is an *extremely* good idea to back up your whole $PGDATA directory
tree (with tar or some such) before attempting such desperate measures,
so that you can undo any self-inflicted damage if you get it wrong...

            regards, tom lane

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

Предыдущее
От: Tomas Berndtsson
Дата:
Сообщение: connection failed in threaded application
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: jdbc driver with BigDecimal patch