[postgis-users] upgrade to postgres 8.3.2 on Windows

[Obe, Regina]

I've been playing with the 8.3.2 with PostGIS stackbuilder install and
comparing with my production install.  Most went okay -> moved over one
of my spatial dbs to it.  Did some simple spatial queries.  I do seem to
be running into an issue with Mapserver 5.0 recognizing it.  Strange it
works for some layers, but my more complex layers involving views a
Mapserver error.

Error in msPOSTGISLayerRetrievePGVersion(): Error executing POSTGIS
statement (msPOSTGISLayerRetrievePGVersion():select substring(version()
from 12 for (position('on' in version()) - 13))

Although querying the view directly in postgresql works fine.

I haven't done enough work to determine if its an issue with the way I
upgraded or some incompatibility between Mapserver and the new
PostgreSQL install.  The same map file worked fine under 8.2 1.3.1
server.

Hope that helps,
Regina
 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Mark
Cave-Ayland
Sent: Friday, February 01, 2008 2:39 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] upgrade to postgres 8.3.2 on Windows

On Mon, 2008-01-28 at 23:19 +0100, Milo van der Linden wrote:
> Hello list,
> 
> Today I ran into an error on my postGIS database server. The database
is 
> hosted on Windows Server 2003 and is currently postgres version 8.2.5 
> with postgis 1.3.1-1
> 
> The error that I recieved said:
> 
> FATAL: could not create sigchld waiter thread: error code 1455 
> 2008-01-28 12:03:39 LOG: logger shutting down
> 
> I found that this is a known bug with postgres on windows when you
reach 
> more then 300 concurrent connections.
> 
> Is it safe for me to upgrade to postGres 8.3.x? Will I be able to use 
> the latest windows postgis build that seems to be on: 1.3.2?
> 
> My system is in production so I just want to make sure.
> 
> Kind regards!
> 
> Milo van der Linden


Hi Milo,

Win32 PostGIS 1.3.2 for PostgreSQL 8.3 is available as part of the
StackBuilder infrastructure. Unfortunately due to the large amount of
manual work involved for an upgrade, I've had to mark the package as
non-upgradeable, however it should install just fine and you should be
able to move tables across from an old installation with pg_dump with no
problem.

Note: Make sure you are running the latest 8.3RC2 release - the
installer would hang part way through in earlier releases due to a
PostgreSQL bug.

Let us know how you get on!


ATB,

Mark.

-- 
ILande - Open Source Consultancy
http://www.ilande.co.uk


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.