On 07/16/2014 07:08 AM, Shaun Thomas wrote:
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.ge25...@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 delete the 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. Will that actually work, though? Or is it too late, since something has 
already requested that invalid transaction? What do we do?

See here:

https://wiki.postgresql.org/wiki/20140702pg_upgrade_fix


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




______________________________________________

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




--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to