Re: [GENERAL] Invalid magic number 0000 in log file

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [GENERAL] Invalid magic number 0000 in log file
Дата
Msg-id c70cc790-6734-1feb-44e6-e9431c604ac1@2ndquadrant.com
обсуждение исходный текст
Ответ на [GENERAL] Invalid magic number 0000 in log file  (Moreno Andreo <moreno.andreo@evolu-s.it>)
Ответы Re: [SPAM] Re: [GENERAL] Invalid magic number 0000 in log file
Список pgsql-general
On 8/25/17 14:24, Moreno Andreo wrote:
> I know that's related to XLOG files, but do not have idea on how to deal
> with it. I had a quick googling but found nothing but "your files are
> corrupted. You'd better initdb."

That's pretty much it.

You might not have to initdb if you have an uncorrupted copy of the WAL
files somewhere (i.e., a backup).  But then I would have concerns about
what else might be corrupted.

> Then I bumped into this (old) post from Alvaro
>
> https://www.postgresql.org/message-id/20070515173401.GB12731@alvh.no-ip.org
>
> If it's  applicable, is it still valid or too many things have changed?

That doesn't seem related.

--
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Willy-Bas Loos
Дата:
Сообщение: Re: [GENERAL] londiste3: removing a node that does not exist
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [GENERAL] Get user defined type OID (PostgreSQL extension in C)