Re: Corruption on production system

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Corruption on production system
Дата
Msg-id 20050426014252.GA31204@dcc.uchile.cl
обсуждение исходный текст
Ответ на Corruption on production system  ("Eric B. Ridge" <ebr@tcdi.com>)
Ответы Re: Corruption on production system  ("Eric B. Ridge" <ebr@tcdi.com>)
Список pgsql-general
On Mon, Apr 25, 2005 at 08:24:03PM -0400, Eric B. Ridge wrote:

> Is page header corruption a known issue with 7.3.6 and should I
> upgrade to 7.3.9 at the same time that I'm restoring this table from
> backup?

Well, you can get a page header corruption on any release as long as you
have faulty hardware ... RAM randomly dropping bits is not unheard of.
Have you run memtest?

If you don't mind losing that page of data, you could turn on
zero_damaged_pages on postgresql.conf.  If you do, you could try
pg_filedump (to be found somewhere on sources.redhat.com/rhdb IIRC) to
examine the damaged page more closely.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"Vivir y dejar de vivir son soluciones imaginarias.
La existencia está en otra parte" (Andre Breton)

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: question about about future 8.1 and IN, INOUT, and OUT parameters
Следующее
От: "Eric B. Ridge"
Дата:
Сообщение: Re: Corruption on production system