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

From: Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [SPAM] Re: Invalid magic number 0000 in log file
Date: 2017-08-28 08:54:45
Message-ID: 48a98a76-7257-11c6-fd4c-9ae991f6146d@evolu-s.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Il 25/08/2017 22:01, Peter Eisentraut ha scritto:
> 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.
Thanks, I'll report to the customer
>
> 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.
Probably system was not booting because of a faulty hard disk, and the
fault also involved some WAL files. Once reinstalled, the system marked
as unusable the faulty sectors and everything is fine now, except for
what was corrupted before..........
I'll tell him to have a deep check of OS events and of the disk itself.

Thanks
Moreno.-

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christoph Moench-Tegeder 2017-08-28 11:06:31 Re: Logging the fact that a log was shipped
Previous Message Michael Paquier 2017-08-28 06:34:09 Re: Extension coverage