[postgis-users] crashing PostgreSQL connections

James Marca jmarca at translab.its.uci.edu
Mon May 16 09:18:52 PDT 2005


Been away from email for a while.  Replies inline:
At approximately Wed, May 04, 2005 at 11:39:10AM +0200, Markus Schaber wrote:
> Hi, James,
> 
> James Marca wrote:
> 
> > james at emma:~$ psql -U slash -d crash -c "SELECT 'SRID=32611;POINT(414160.003328498 3726591.60052614))'::geometry;"
> > server closed the connection unexpectedly
> >         This probably means the server terminated abnormally
> >         before or while processing the request.
> > connection to server was lost
> 
> I cannot reproduce this behaviour with current 1.0.1CVS branch, I get
> "ERROR:  parse error - invalid geometry"
> 
> Could you give us the output of SELECT postgis_full_version()? Also:
> Which platform do you use? (unix command "uname -a" may help).

tracer=> select postgis_full_version();
postgis_full_version
-------------------
 POSTGIS="1.0.0RC3" GEOS="2.1.0" PROJ="Rel. 4.4.9, 29 Oct 2004"
 USE_STATS DBPROC="0.2.0" RELPROC="0.2.0"
(1 row)

Ah, perhaps that explains my problem?  I *thought* I was using 1.0 on
my development box.  Oh well, I will recompile today or tomorrow and
check again.

As to the platform, I am running Linux on an x86_64 (Athlon 64),
kernel 2.6.10, more or less slackware 10.1 but everything recompiled
by hand for x86_64 and with no 32 bit emulation.

James



More information about the postgis-users mailing list