Re: how to use pg_resetxlog

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: how to use pg_resetxlog
Дата
Msg-id 3343.1066667836@sss.pgh.pa.us
обсуждение исходный текст
Ответ на how to use pg_resetxlog  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Список pgsql-general
"Johnson, Shaunn" <SJohnson6@bcbsm.com> writes:
> 1) How do you use  pg_resetxlog?

Read the README file for it.

> 2) Am I at risk of losing all of my data
>    if I use this?

You're at risk of having corrupted data, but I think that's true already
because of the disk failure.

> 3) Some info at groups.google.com suggest that I will
>    have to initdb - I figured that would be good anyway, but
>    how does pg_resetxlog play into this?

After pg_resetxlog you should be able to dump your database.  I'd
recommend doing that, then initdb, reload the dump, look for
inconsistencies ...

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Pgsql 7.3.3 on redhat 7.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: how to use pg_resetxlog