Andrea, On second thought don't think it's the config. We did a diff and not too much difference and setting the differences didn't help.
It just doesn't always crash the first time, but does if you run again immediately so some sort of memory leak. Andrea -- you want to just change the log_error_verbosity = verbose in your config file and send the PostgreSQL folks a bug report. I think you are right its something in 9.0 doing it. When we enable verbose on ours, it looks like its crashing when its trying to vacuum LOG: 00000: last completed transaction was at log time 2010-10-02 19:52:00.289-04 LOCATION: StartupXLOG, .\src\backend\access\transam\xlog.c:6258 LOG: 00000: database system is ready to accept connections LOCATION: reaper, .\src\backend\postmaster\postmaster.c:2402 LOG: 00000: autovacuum launcher started LOCATION: AutoVacLauncherMain, .\src\backend\postmaster\autovacuum.c:404 LOG: 00000: server process (PID 3664) was terminated by exception 0xC0000005 Leo and Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paragon Corporation Sent: Saturday, October 02, 2010 7:27 PM To: 'PostGIS Users Discussion' Subject: Re: [postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows Andrea, We did some more tests. I think its something in the new config that is too high or low. If we copy our default PostgreSQL 8.4.4 postgresql.conf to our PostgreSQL 9.0 install, your script works fine. Thanks, Leo and Regina http://www.postgis.us -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paragon Corporation Sent: Saturday, October 02, 2010 7:18 PM To: 'PostGIS Users Discussion' Subject: Re: [postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows Andrea, We tested too on 9.0 and our 8.4.4 install and we came up with same results as you Crashes on 9.0 Works fine 0n 8.4.4 Both running on Windows 7 with PostGIS 1.5.2, GEOS 3.2.2 I suppose it could just be a setting in the config that is too high or low on 9.0 Anyrate does seem to be a PostgreSQL 9.0 issue. Whether its isolated to windows is a different question. Maybe Paul, Mark, or Kevin or someone on Linux with 9.0 installed can test . Thanks, Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Andrea Peri 2007 Sent: Saturday, October 02, 2010 7:03 PM To: [email protected] Subject: [postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows Hi, I've test again. >I guess to rule out PostGIS as the culprit -- you could try upgrading >your Postgres 8.4.4 to 1.5.2 (a quick way is to copy over the >postgis-1.5.dll ,libxml, and geos binaries in bin folde) -- making sure >to backup your existing and restart. Binaries are available Postgis >1.5 8.4 binaries. >http://www.postgis.org/download/windows/#windbinaries The execution of the script on the PG8.4.4 with Postgis 1.5.2 terminate without any problem. As more test, I try to re-install PG9.0 + Postgis 1.5.2. But without any result. PG 9.0 crash again with that script sql. Regards, Andrea. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
