Arto, You can't use postgresql 9.1.1-windows with postgis-pg90-binaries-1.5.3. zip. Those are incompatible. We have builds for upcoming PostGIS 2.0 for PostgreSQL 9.1 windows which will work together. In the experimental section: http://www.postgis.org/download/windows/experimental.php#PostGIS_2_0_0 We were hoping that PostGIS 2.0 would be released before PostgreSQL 9.1 so that we wouldn't have to produce PostGIS 1.5 binaries for PostgreSQL 9.1. given that that didn't happen and PostGIS 2.0 will be months from now, I guess we'll need to produce 1.5.3 binaries :(. If you can wait till this weekend or Monday, we should have new batches of binaries ready for 1.5.3 (Pg 9.1) and PostGIS 2.0 (Pg 9.1). The PostGIS 2.0 -- next batch we release which we hope to do in the next day or so will include the new KNN GIST support for 9.1 and new raster / raster intersects functions. or you can stay on the stable less fun side and wait till this weekend or Monday for us to prepare the 1.5.3 (Pg 9.1 builds). -- Regarding: "5) Just wondering: to create a PostGIS enabled database, is the makepostgisdb.bat usage a must? Last year at least it was possible to use PostGIS template in PgAdmin III to create a new database." The makepostgisdb.bat can make a template database for you. You just have to change the variables in there and unremark out the update template line. Hope that helps, Regina and Leo http://www.postgis.us
_____ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Arto Vuorela Sent: Wednesday, September 28, 2011 5:48 AM To: postgis-users@postgis.refractions.net Subject: [postgis-users] PostGIS installation in Windows 32-bit Hello I aim to use postgresql-9.1.1-1-windows.exe and postgis-pg90-binaries-1.5.3.zip (aiming to use with zigGIS, PgMap or ArcGIS 10.1, map service). Some basic questions for Windows Server 2003 installation: 1) PostGIS manuals say "A complete installation of PostgreSQL (including server headers) is required." Were the server headers automatically installed? I chose PgOleDB, pgJDBC and psqlODBC database drivers for PostgreSQL, if that matters. 2) Should I worry also about this (from the manual as well)?: For GEOS functionality, when you install PostgresSQL you may need to explicitly link PostgreSQL against the standard C++ library: LDFLAGS=-lstdc++ ./configure [YOUR OPTIONS HERE] 3) PostGIS JDBC driver I understand to be different from PostgreSQL JDBC driver. <http://postgis.refractions.net/pipermail/postgis-devel/2006-November/002375 .html> http://postgis.refractions.net/pipermail/postgis-devel/2006-November/002375. html says Versions 1.1.5 and 1.1.6 of the PostGIS-JDBC-Drivers are available at <http://lists.refractions.net/m2/org/postgis> http://lists.refractions.net/m2/org/postgis. Someone also mentioned in discussions that he found postgis-jdbc 1.3.5 on public Maven repositories. What is Maven or Pom I don't even know. Those all may be old - should I use the non-debug jar version at JDBC SNAPSHOT on page http://postgis.refractions.net/download/? Where should the chosen version be installed, or how? By merely listing it in CLASSPATH variable, as the PostgreSQL JDBC driver? The PostGIS's README.txt does not tell such things. 4) As PostGIS is not found under Stack Builder yet for 9.1, I should put the binaries in correct places. Are the postgis-pg90-binaries-1.5.3 contents put in the installation folder (...\PostgreSQL\9.1\, so that most files go under the three subfolders)? The README.txt does not tell this either. 5) Just wondering: to create a PostGIS enabled database, is the makepostgisdb.bat usage a must? Last year at least it was possible to use PostGIS template in PgAdmin III to create a new database. Arto
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
