Re: Restoring fscked up postgres 7.1

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Restoring fscked up postgres 7.1
Дата
Msg-id 87651qagck.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Restoring fscked up postgres 7.1  (Kristaps Armanis <krisha@grafton.lv>)
Список pgsql-general
Kristaps Armanis <krisha@grafton.lv> writes:

> Is there any solution?

I think what you have to do is use pg_resetxlog with -x and a value just shy
of 2^32. then pg_dump and restore into a fresh database. I've never done it
though so perhaps you should wait until someone with more experience speaks
up. I would also suggest taking a cold backup of the bad database before
running pg_resetxlog.

--
greg

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

Предыдущее
От: Mário Gamito
Дата:
Сообщение: static pgadmin
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Multiline plpython procedure