On Tue, Jul 20, 2010 at 17:31, Etienne Dube <etd...@gmail.com> wrote: > On 09/02/2010 4:09 PM, Etienne Dube wrote: >> >> Magnus Hagander wrote: >>> >>> IIRC, we've had zero reports on whether the patch worked at all on 8.2 >>> in an environment where the problem actually existed. So yes, some >>> testing and feedback would be much apprecaited. >>> >>> //Magnus >> >> Thanks for your quick reply. >> We upgraded to Service Pack 2 and it solved the problem. Nevertheless, >> I'll try to reproduce the issue under a Win2008 SP1 VM to see whether the >> patch makes a difference. 8.2.x win32 binaries are built using MinGW right? >> >> Etienne >> >> > > > The "could not reattach to shared memory" bug came back to bite us, this > time on a production machine running Windows Server 2008 R2 x64. I manually > applied the patch against the 8.2.17 sources and installed the build on a > test server. It has been running for two days without any issue. We'll see > after a while if the patch actually fixes the problem (it seems to happen > only after the postgres service has been up and running for some time) but > in case you want to include this fix in a future 8.2.18 release, I've > attached the new patch to apply against the REL8_2_STABLE branch.
Yes, I think it's time to backpatch this to 8.2 - it has worked very well on 8.3 and 8.4, and we've had a couple of good reports on 8.2 by now. So I've done that, so it should be in the next 8.2 version. In fact, there was a small bug in the patch that broke all non-win32 platforms, so I fixed that while at it :-) -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers