Re: 9.4 pg_control corruption

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Singer <steve(at)ssinger(dot)info>
Cc: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 9.4 pg_control corruption
Date: 2014-07-09 02:56:12
Message-ID: 10934.1404874572@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Steve Singer <steve(at)ssinger(dot)info> writes:
> On 07/08/2014 10:14 PM, Tom Lane wrote:
>> There's no obvious reason to think that this pg_control file is corrupt
>> on its own terms, but the pg_controldata version you're using expects
>> the 942 layout. The fact that the server wasn't complaining about this
>> suggests that you've not recompiled the server, or at least not xlog.c.

> The server is complaining about that, it started to after the crash

Then you updated your sources, recompiled and reinstalled, but failed to
restart the server when you did that. Else it would have complained on
the spot.

If you had any valuable data in the installation, we could talk about how
to get it out; but since you didn't I'd suggest just re-initdb and move
on. I don't see anything unexpected here.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2014-07-09 03:13:49 Re: postgresql.auto.conf and reload
Previous Message Steve Singer 2014-07-09 02:36:41 Re: 9.4 pg_control corruption