Re: Bad pg_xlog with no redo

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bad pg_xlog with no redo
Дата
Msg-id 27197.1118803131@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bad pg_xlog with no redo  (Pailloncy Jean-Gerard <jg@rilk.com>)
Список pgsql-general
Pailloncy Jean-Gerard <jg@rilk.com> writes:
> I have a drive with a bad zone inside the file pgsql/pg_xlog/
> 0000005D000000A1.

> How may I zap the bad pgxlog file ?

pg_resetxlog.  Heed the warnings that your database is not guaranteed
good after you do this.  I'd recommend a dump and reload ... and as much
manual cross-checking as you can manage.

            regards, tom lane

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

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: PG 8.0.1 is getting slow in 24 hours. Only daily VACUUM FULL helps
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: (NONE)