[postgis-users] What is the last Windows Version of PostGIS and PostgreSQL?
Dear friends, What is the last version of *PostGIS *and *PostgreSQL *(*pgAdmin III *version included) that I can install? Where i can download and install in Windows XP Professional SP3? Thanks you. Tradecarto ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows
Andrea, I assume you are running 32-bit? No we haven't run into any issues yet, but haven't migrated our bigger apps to PostgreSQL 9.0 yet. Can you provide a sample query that you are running that triggers this error? If its loading from file, maybe a sample load file and script. You can provide that to us off list if you want? 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 Two changes we did make -- which hopefully is not the cause of this is that we are no longer statically compiling in libxml. In the 1.5.1 we did because we were getting crashes when using GeomFromKML/GML, but we found a work around for it which seemed to work fine. The other is the 1.5.2 is compiled against GEOS 3.2.2 instead of GEOS 3.2.0 I assume your load script is not using ST_GeomFromGML, KML etc? If it is, we may need to reinvestigate. If it is a PostGIS issue -- it might also be in the GEOS 3.2.2 in which case, we would like to rule out PostGIS as the culprit. I doubt this since we have been running fairly intensive queries in PostgreSQL 8.4 using the newer GEOS. Thanks, Leo and Regina http://www.postgis.us -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Andrea Peri 2007 Sent: Saturday, October 02, 2010 7:43 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows 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 0xC005 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. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] What is the last Windows Version of PostGIS andPostgreSQL?
Tradecarto, We haven't posted PostGIS 1.5.2 on StackBuilder yet, but you can download it from http://www.postgis.org/download/windows/ (It will be the same setup files we'll be posting to stack builder, so even if you use stack builder, it will show as installed once we post them) So as far as most up to date you can run on windows production: PostGIS 1.5.2, PostgreSQL 9.0 32-bit, PgAdmin 1.120 So you can download PostgreSQL 9.0 from http://www.enterprisedb.com/products/pgdownload.do#windows PostGIS 1.5.2 from http://www.postgis.org/download/windows/ (and in the next week from Application Stack Builder menu option in PostgreSQL) -- experimental stuff PostGIS 1.5.2 (we have PostGIS 2.0.0 experimental binaries too, but those are just for testing -- not production use -- http://www.postgis.org/download/windows/experimental.php ) We'll be posting PostGIS 2.0.0 experimental binaries for PostgreSQL 9.1 alpha (32-bit) in the next week or so and updating hte otehrs as well to reflect the latest changes in the upcoming PostGIS 2.0.0 Thanks, Leo and Regina http://www.postgis.us _ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Francisco José Reyes Peralta Sent: Saturday, October 02, 2010 7:56 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] What is the last Windows Version of PostGIS andPostgreSQL? Dear friends, What is the last version of PostGIS and PostgreSQL (pgAdmin III version included) that I can install? Where i can download and install in Windows XP Professional SP3? Thanks you. Tradecarto ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Trouble Installing PostGIS 1.5.2 on Enterprise Linux
Tom, Its unclear from your note if this is your problem, but from experience, the most common problem people run into when compiling PostGIS on Cent OS/Red Hat EL is the binding between the geos library linking and postgis-1.5.so. We documented a workaround here - http://www.postgresonline.com/journal/archives/147-Compiling-PostGIS-1.5-and -installing-after-Yum-PostgreSQL-Install.html -- way down in the problems section Basically you want to check to make sure the links are right by running ldd -d /usr/lib64/pgsql/postgis-1.5.so ldd -d /usr/lib64/pgsql/postgis-1.5.so | grep libgeos ldd -d /usr/lib64/pgsql/postgis-1.5.so | grep libproj And then correct them. We just change the symlinks to point to the right place -- which we have documented in the above article. I think Mark Cave-Ayland or Sandro Santilli had a more elegant way of fixing this issue, but can't find that item. If they are around, maybe they can chime in on this. We should probably note this in the installation and FAQ some where since it seems several people have been bitten by this. As a side note --with-pgsql is obsolete -- you should be using -- --with-pgconfig=FILE (where FILE is path to your postgresql config) Leo and Regina http://www.postgis.us From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Tom Liebert Sent: Friday, October 01, 2010 1:02 PM To: postgis-users Subject: [postgis-users] Trouble Installing PostGIS 1.5.2 on Enterprise Linux I've got some experience installing PostGIS on Postgres 8.4 running on Ubuntu Linux, but am running into issues on CentOS 5.5. I've got all dependencies installed: Geos-3.2.2, Proj-4.7.0, GDAL/OGR 1.7.2 (!), libxml2-2.7.6 and everything seems to go well during my configure: // ./configure --with-pgconfig=/usr/bin/pg_config \ --with-xml2config=/usr/local/src/libxml2-2.7.6/xml2-config \ --with-proj \ --with-geosconfig=/usr/local/bin/geos-config \ --with-pgsql // The make results: // PostGIS was built successfully. Ready to install. // But make install isn't as neat: // /bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c shp2pgsql /usr/bin make[1]: Leaving directory `/usr/local/src/postgis-1.5.2/loader' // And, my resulting attempts to create a PostGIS database do not succeed. Here's my commands: #login as postgres sudo su postgres #create database stuff createdb example_db createlang plpgsql example_db psql -d example_db -f /usr/share/pgsql/contrib/postgis-1.5/postgis.sql psql -d example_db -f /usr/share/pgsql/contrib/postgis-1.5/spatial_ref_sys.sql #logout of postgres user exit Anyone have advice on what to look for in a successful install? ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Hello
And there is a more recent tutorial available here: http://workshops.opengeo.org/postgis-intro/ On Sat, Oct 2, 2010 at 9:00 AM, MarkW mark.wi...@gmail.com wrote: Nitesh, (There is a good tutorial about mapserver here: http://mapserver.org/tutorial/index.html ) As for the PostGIS part, it's easier than you might think. Try looking at some of the tutorials at http://www.bostongis.com/ particularly this section on UMN datasources here: http://www.bostongis.com/?content_name=umn_datasources#19 Also, the Foss4G site has a very easy to use get started tutorial here: http://2007.foss4g.org/workshops/W-04/ Mark On Sat, Oct 2, 2010 at 2:17 AM, Nitesh Phadatare nsp@gmail.com wrote: how to use postgis on MapServer. means i want steps how to write mapfile an how to load it? also how to make visible map on MapServer -- Nitesh Phadatare, INDIA ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Hello
You can try making a map visually in QGIS, then export it to MapServer using a plugin: http://spatialserver.net/qgis2ms/ The conversion isn't always 1-to-1, but it a good visual start to developing MAP files. -Mike On 1 October 2010 23:17, Nitesh Phadatare nsp@gmail.com wrote: how to use postgis on MapServer. means i want steps how to write mapfile an how to load it? also how to make visible map on MapServer -- Nitesh Phadatare, INDIA ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows
Andrea, I assume you are running 32-bit? I'm running Postgres 9.0 and 8.4.4 both 32bit on Windows7-64bit. Can you provide a sample query that you are running that triggers this error? If its loading from file, maybe a sample load file and script. You can provide that to us off list if you want? Yes, I provide you offlist a script that always crash my Postgres 9.0. The script is a bit huge (10 mbyte) because this is the exact sequence my program do before the PG9 crash. Launching the script with psql, the PG9 crash about 1 minute after the script is terminate. The script do simply create many table and start to fill they with many inserts in the public schema. I test this script with PG 8.4.4 instance (with postgis 1.5.1) and nothing happened. Instead with PG 9.0 (+ postgis 1.5.2) the PG9.0 crash. I assume your load script is not using ST_GeomFromGML, KML etc? If it is, we may need to reinvestigate. No, the script use only the GeomFromText(..). Two changes we did make -- which hopefully is not the cause of this is that we are no longer statically compiling in libxml. In the 1.5.1 we did because we were getting crashes when using GeomFromKML/GML, but we found a work around for it which seemed to work fine. The other is the 1.5.2 is compiled against GEOS 3.2.2 instead of GEOS 3.2.0 ... In effect the Postgis 1.5.1 of the PG 8.4.4 istance is using the Geos 3.3.0 I have compiled from trunk with VC++. Instead the PG 9.0 is using the Geos 3.2.2 (from postgis 1.5.2) 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 Thx, I do this upgrade. and re-test the script. Regards Andrea. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Andrea Peri 2007 Sent: Saturday, October 02, 2010 7:03 PM To: postgis-users@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Andrea Peri 2007 Sent: Saturday, October 02, 2010 7:03 PM To: postgis-users@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Hanging Postgres 9.0 + Postgis 1.5.2 on windows
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: 0: 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: 0: database system is ready to accept connections LOCATION: reaper, .\src\backend\postmaster\postmaster.c:2402 LOG: 0: autovacuum launcher started LOCATION: AutoVacLauncherMain, .\src\backend\postmaster\autovacuum.c:404 LOG: 0: server process (PID 3664) was terminated by exception 0xC005 Leo and Regina -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@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-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Andrea Peri 2007 Sent: Saturday, October 02, 2010 7:03 PM To: postgis-users@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users