We've been affected by a pg_upgrade bug. What do we do next? - Mailing list pgsql-general

From Shaun Thomas
Subject We've been affected by a pg_upgrade bug. What do we do next?
Date
Msg-id 0683F5F5A5C7FE419A752A034B4A0B9797AF6025@sswchi5pmbx2.peak6.net
Whole thread Raw
Responses Re: We've been affected by a pg_upgrade bug. What do we do next?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hey,

We performed an upgrade via pg_upgrade from 9.1 to 9.3 a while back, and I'm almost certain we were bitten by this bug:

http://www.postgresql.org/message-id/20140530121631.GE25431@alap3.anarazel.de

Finding the discussion is nice... but what do we do to fix this? I read through the discussion, and it *seems* we can
deletethe 0000 file and restart since it's only an 8k file and we haven't gone far enough to wrap into a new 0000 file.
Willthat actually work, though? Or is it too late, since something has already requested that invalid transaction? What
dowe do? 

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas@optionshouse.com




______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email


pgsql-general by date:

Previous
From: Marc Mamin
Date:
Subject: Re: php password authentication failed for user ...
Next
From: Adrian Klaver
Date:
Subject: Re: We've been affected by a pg_upgrade bug. What do we do next?