From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
---|---|
To: | Moreno Andreo <moreno(dot)andreo(at)evolu-s(dot)it>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Invalid magic number 0000 in log file |
Date: | 2017-08-25 20:01:20 |
Message-ID: | c70cc790-6734-1feb-44e6-e9431c604ac1@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2017-08-25 20:06:55 | Re: Get user defined type OID (PostgreSQL extension in C) |
Previous Message | Willy-Bas Loos | 2017-08-25 19:57:34 | Re: londiste3: removing a node that does not exist |