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

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] 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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Andrea
Peri 2007
Sent: Saturday, October 02, 2010 7:03 PM
To: postgis-users at postgis.refractions.net
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
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users