Search Postgresql Archives

We've been affected by a pg_upgrade bug. What do we do next?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxxx

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?

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




______________________________________________

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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux