[postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows

[Andrea Peri 2007]

  Hi,

I experience a bad crash of the couple Postgres 9.0 + Postgis 1.5.2 on 
windows 7.

The crash of postgres occur meanwhile I run a my program executable 
that  read from a textual file many data and load them on some geometry 
tables .

This procedure is very tested because is the same that I use without any 
problem on the couple

Postgres 8.4.4 + Postgis 1.5.1 always on the same windows 7 machine.

Infact after see this crash I immediatly retry the same procedure on the 
istance of
Postgres 8.4.4 + postgis 1.5.1 on the same data and no error occur.

I see the log of postgres 9.0 and see this error.

2010-10-01 22:38:56 CEST LOG:  database system is ready to accept 
connections
2010-10-01 22:44:20 CEST LOG:  server process (PID 2540) was terminated 
by exception 0xC0000005
2010-10-01 22:44:20 CEST HINT:  See C include file "ntstatus.h" for a 
description of the hexadecimal value.
2010-10-01 22:44:20 CEST LOG:  terminating any other active server processes
2010-10-01 22:44:20 CEST WARNING:  terminating connection because of 
crash of another server process
2010-10-01 22:44:20 CEST DETAIL:  The postmaster has commanded this 
server process to roll back the current transaction and exit, because 
another server process exited abnormally and possibly corrupted shared 
memory.
2010-10-01 22:44:20 CEST HINT:  In a moment you should be able to 
reconnect to the database and repeat your command.
2010-10-01 22:44:20 CEST WARNING:  terminating connection because of 
crash of another server process
2010-10-01 22:44:20 CEST DETAIL:  The postmaster has commanded this 
server process to roll back the current transaction and exit, because 
another server process exited abnormally and possibly corrupted shared 
memory.
2010-10-01 22:44:20 CEST HINT:  In a moment you should be able to 
reconnect to the database and repeat your command.
2010-10-01 22:44:20 CEST LOG:  all server processes terminated; 
reinitializing
2010-10-01 22:44:31 CEST FATAL:  pre-existing shared memory block is 
still in use
2010-10-01 22:44:31 CEST HINT:  Check if there are any old server 
processes still running, and terminate them.

I really think this error is due to Postgres 9.0 and no relation there 
is with Postgis 1.5.2.

But I don't know how to do to retrieve more information to understand 
what is happening.

So I like to know if there is others with these problems of an istance 
of postgres 9.0 that is hanging.

Thx,

Andrea.