Re: [INTERFACES] Seeking advice on how to deal with the dreaded stuck spinlock problem on NT - Mailing list pgsql-interfaces

From Dan Rosner
Subject Re: [INTERFACES] Seeking advice on how to deal with the dreaded stuck spinlock problem on NT
Date
Msg-id 38986A8D.C22F0A69@scn.org
Whole thread Raw
In response to RE: [INTERFACES] Seeking advice on how to deal with the dreaded stuck spinlock problem on NT  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-interfaces
Hiroshi Inoue wrote:
> 
> > -----Original Message-----
> > From: owner-pgsql-interfaces@postgreSQL.org
> > [mailto:owner-pgsql-interfaces@postgreSQL.org]On Behalf Of Dan Rosner
> >
> > Does anyone have any advice/suggestions about how to deal with
> > stuck spinlock problems while running postgres 6.5.3
> > on cygwin B20?
> >
> 
> Did you apply the patch to cygipc library ?
> 
> Regards.
> 
> Hiroshi Inoue
> Inoue@tpf.co.jp

Thanks for your suggestion.  It leads me to another question.

I built up Postgres 6.5.3 on NT using Kevin Lo's instructions, which 
didn't mention applying the patch you describe to the Cygwin32 IPC 
Package by Ludovic LANGE .  However, I just looked at the Microsoft
NT FAQ on postgresql.org, and now see there is a patch appended to the
end
of the NT installation instructions.  The instructions say to...

3. Apply the patch at the end of this file to the cygipc sources  before compiling the library.

This may be my problem.  I assumed the patch was already in 6.5.3,
though now
I'm not sure how to apply the patch.  Would someone mind telling me the 
command line to use?  It seems I should save the patch to somefile and
then do something like this in the root of the cygipc sources:

patch -p0 < somefile

Is this correct?  Assuming the patch was correctly applied, I would then 
just configure, make and install my binaries again.  And hopefully the 
spinlock problem will go away.  Is this the correct way to apply the
patch?

Dan


pgsql-interfaces by date:

Previous
From: "Ken J. Wright"
Date:
Subject: pg_pwd trouble
Next
From: "Achillefs Margaritis"
Date:
Subject: database migration