Re: postgres xlog crashes - recovery procedure

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: postgres xlog crashes - recovery procedure
Дата
Msg-id 20021030102314.C9431@mail.libertyrms.com
обсуждение исходный текст
Ответ на postgres xlog crashes - recovery procedure  (Alexander Korobov <akorobov@cisco.com>)
Список pgsql-admin
On Tue, Oct 29, 2002 at 01:47:40PM -0500, Alexander Korobov wrote:
>
> I'm aware of contrib/pg_resetxlog but this does not seem to be reliable tool.

It's as reliable as it can be, as far as I know.  There is the
potential for data loss, but that's the problem with having lost your
WAL.

> Are there any postgres specific recovery procedures and /or documentation on how
> to prevent such situations?

The recovery in this case is pg_resetxlog.  As for prevention, it
depends on what happened.  Any ideas?

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


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

Предыдущее
От: dima
Дата:
Сообщение: Re: pg_hba.conf on win32
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Connection refused errors