Changes between Version 80 and Version 81 of UsersWikiWinCompile

Timestamp:

Oct 21, 2009, 6:03:26 AM (15 years ago)

Author:

robe

Comment:

—

UsersWikiWinCompile

@@ -139 +139 @@
       10. ''configure --prefix=/c/mingw && make && make install'' 
  
-'''10. Compiling libxml2 '''[[BR]]
+'''9. Compiling PostgreSQL'''[[BR]]    
+Download latest PostgreSQL source from http://www.postgresql.org/ftp/source/ and untar in C:\thesrc[[BR]]
+move to folder[[BR]]
+      1. ''cd /c/thesrc/postgresql-8.3.7'' (the version of today)
+      2. ''configure --prefix=/c/postgres && make && make install''
+      3.  If you want to be able to do a full make check on PostGIS, [UsersWikiWinCompileInitdb Initialize the postgresql database cluster]
+    
+note that we now have changed the install-directory from mingw to postgres
+
+if you get an error something like:[[BR]]
+e:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sspi.h:60: error: syntax error before SECURITY_STRING[[BR]]
+In file included from e:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/security.h:39, [[BR]]
+from libpq-int.h:57, [[BR]]
+from fe-auth.h:18, [[BR]]
+from fe-auth.c:48: [[BR]]
+e:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/ntsecpkg.h:123: error: syntax error before SECURITY_STRING
+
+the solution is to edit two of the source-files.[[BR]]
+In both files: [[BR]]
+postgresql-8.3.7/src/include/libpq/libpq-be.h [[BR]]
+and [[BR]]
+postgresql-8.3.7/src/interfaces/libpq/libpq-int.h:
+
+add a new include-file:[[BR]]
+#ifdef ENABLE_SSPI[[BR]]
+#define SECURITY_WIN32[[BR]]
+#include <ntsecapi.h> '''<- Add this include'''[[BR]]
+#include <security.h>[[BR]]
+#undef SECURITY_WIN32[[BR]]
+
+you can read about this here:[[BR]]
+http://pgolub.wordpress.com/2008/12/15/building-postgresql-client-library-using-mingw-under-winxp-sp3/ [[BR]]
+and[[BR]]
+http://postgresqlorg.blogspot.com/2008/09/hackers-83-4-vista-mingw-initdb.html [[BR]]
+
+'''10. Compiling GEOS'''[[BR]]
+Download latest GEOS-source from trac.osgeo.org/geos/ ( http://download.osgeo.org/geos/geos-3.1.1.tar.bz2 ) 
+and copy into C:\thesrc
+
+Extract with:
+cd /thesrc
+
+bzip2 -d -c geos-3.1.1.tar.bz2 | tar -xvf -
+
+
+Do the same as with postgresql, extract to c:\thesrc [[BR]]
+in msys terminal move to the GEOS source-code directory[[BR]]
+     1. ''configure --prefix=/c/postgres && make && make install''
+     2. To strip all the debug info weight from the libgeos-3-1-1.dll run
+
+          strip /c/postgres/bin/libgeos-3-1-1.dll
+
+NOTE: If you are compiling the latest GEOS 3.2 (geos/trunk, you may get an error because of a bug in MingW). GEOS 3.2 is needed 
+to take advantage of the new ST_Buffer enhancements in PostGIS 1.5+ and also some fixes for topology exceptions in intersects and intersection.
+
+I had to comment out like below -- change lines (159, 166) to below (in C:\MinGW\include\c++\3.4.5\cwchar  (same issue exists under gcc 4.4.0)  
+  //using ::swprintf;  
+
+  //using ::vswprintf;
+
+refer to [http://sourceforge.net/tracker/index.php?func=detail&aid=2373234&group_id=2435&atid=102435] 
+and [http://lists.osgeo.org/pipermail/geos-devel/2009-June/004240.html] for details
+
+If you are runnning gcc 4.4.0 and you get complaints about link g++ you probably need to do this too:
+
+and changing library_names='libstdc++.dll.a'
+
+to 
+#library_names='libstdc++.dll.a' 
+
+library_names='libstdc++.a'
+
+As alluded to here http://www.nabble.com/GCC-4.4.0-fails-with-GMP-td24191439.html 
+
+
+'''11. Compiling Proj'''[[BR]]
+Download latest Proj from trac.osgeo.org/proj/ (http://download.osgeo.org/proj/proj-4.6.1.zip ) [[BR]]
+in msys terminal move to the Proj source-code directory[[BR]]
+     1. ''./configure --prefix=/c/postgres --enable-shared --disable-static ''
+     2. ''make && make install''
+--Make the libproj.dll and make it dynamically linked
+     3. cd /c/postgres/lib
+     4. gcc -shared -o libproj.dll -Wl,--out-implib=libproj.dll.a -Wl,--export-all-symbols -Wl,--enable-auto-import -Wl,--whole-archive libproj.a -Wl,--no-whole-archive /c/mingw/lib/libmingw32.a 
+
+
+'''12. Installing C-Unit -- needed for PostGIS 1.4 and above make check'''
+      1. download http://sourceforge.net/projects/cunit/files/CUnit/CUnit-2.1-0-winlib.zip
+      2. extract and copy contents to C:\MingW  
+
+'''13. Compiling libxml2 '''[[BR]]
 This is only needed for PostGIS 1.5+.  Libxml2 is used to support the ST_GeomFromGML function.
     a. Download the libxml special from here http://www.pokorra.de/coding/compile_libxml_mingw.html 
@@ -148 +237 @@
     d. ./configure
     e. make && make install
-'''9. Compiling PostgreSQL'''[[BR]]    
-Download latest PostgreSQL source from http://www.postgresql.org/ftp/source/ and untar in C:\thesrc[[BR]]
-move to folder[[BR]]
-      1. ''cd /c/thesrc/postgresql-8.3.7'' (the version of today)
-      2. ''configure --prefix=/c/postgres && make && make install''
-      3.  If you want to be able to do a full make check on PostGIS, [UsersWikiWinCompileInitdb Initialize the postgresql database cluster]
-    
-note that we now have changed the install-directory from mingw to postgres
-
-if you get an error something like:[[BR]]
-e:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/sspi.h:60: error: syntax error before SECURITY_STRING[[BR]]
-In file included from e:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/security.h:39, [[BR]]
-from libpq-int.h:57, [[BR]]
-from fe-auth.h:18, [[BR]]
-from fe-auth.c:48: [[BR]]
-e:/mingw/bin/../lib/gcc/mingw32/3.4.5/../../../../include/ntsecpkg.h:123: error: syntax error before SECURITY_STRING
-
-the solution is to edit two of the source-files.[[BR]]
-In both files: [[BR]]
-postgresql-8.3.7/src/include/libpq/libpq-be.h [[BR]]
-and [[BR]]
-postgresql-8.3.7/src/interfaces/libpq/libpq-int.h:
-
-add a new include-file:[[BR]]
-#ifdef ENABLE_SSPI[[BR]]
-#define SECURITY_WIN32[[BR]]
-#include <ntsecapi.h> '''<- Add this include'''[[BR]]
-#include <security.h>[[BR]]
-#undef SECURITY_WIN32[[BR]]
-
-you can read about this here:[[BR]]
-http://pgolub.wordpress.com/2008/12/15/building-postgresql-client-library-using-mingw-under-winxp-sp3/ [[BR]]
-and[[BR]]
-http://postgresqlorg.blogspot.com/2008/09/hackers-83-4-vista-mingw-initdb.html [[BR]]
-
-'''10. Compiling GEOS'''[[BR]]
-Download latest GEOS-source from trac.osgeo.org/geos/ ( http://download.osgeo.org/geos/geos-3.1.1.tar.bz2 ) 
-and copy into C:\thesrc
-
-Extract with:
-cd /thesrc
-
-bzip2 -d -c geos-3.1.1.tar.bz2 | tar -xvf -
-
-
-Do the same as with postgresql, extract to c:\thesrc [[BR]]
-in msys terminal move to the GEOS source-code directory[[BR]]
-     1. ''configure --prefix=/c/postgres && make && make install''
-     2. To strip all the debug info weight from the libgeos-3-1-1.dll run
-
-          strip /c/postgres/bin/libgeos-3-1-1.dll
-
-NOTE: If you are compiling the latest GEOS 3.2 (geos/trunk, you may get an error because of a bug in MingW). GEOS 3.2 is needed 
-to take advantage of the new ST_Buffer enhancements in PostGIS 1.5+ and also some fixes for topology exceptions in intersects and intersection.
-
-I had to comment out like below -- change lines (159, 166) to below (in C:\MinGW\include\c++\3.4.5\cwchar  (same issue exists under gcc 4.4.0)  
-  //using ::swprintf;  
-
-  //using ::vswprintf;
-
-refer to [http://sourceforge.net/tracker/index.php?func=detail&aid=2373234&group_id=2435&atid=102435] 
-and [http://lists.osgeo.org/pipermail/geos-devel/2009-June/004240.html] for details
-
-If you are runnning gcc 4.4.0 and you get complaints about link g++ you probably need to do this too:
-
-and changing library_names='libstdc++.dll.a'
-
-to 
-#library_names='libstdc++.dll.a' 
-
-library_names='libstdc++.a'
-
-As alluded to here http://www.nabble.com/GCC-4.4.0-fails-with-GMP-td24191439.html 
-
-
-'''11. Compiling Proj'''[[BR]]
-Download latest Proj from trac.osgeo.org/proj/ (http://download.osgeo.org/proj/proj-4.6.1.zip ) [[BR]]
-in msys terminal move to the Proj source-code directory[[BR]]
-     1. ''./configure --prefix=/c/postgres --enable-shared --disable-static ''
-     2. ''make && make install''
---Make the libproj.dll and make it dynamically linked
-     3. cd /c/postgres/lib
-     4. gcc -shared -o libproj.dll -Wl,--out-implib=libproj.dll.a -Wl,--export-all-symbols -Wl,--enable-auto-import -Wl,--whole-archive libproj.a -Wl,--no-whole-archive /c/mingw/lib/libmingw32.a 
-
-
-'''12. Installing C-Unit -- needed for PostGIS 1.4 and above make check'''
-      1. download http://sourceforge.net/projects/cunit/files/CUnit/CUnit-2.1-0-winlib.zip
-      2. extract and copy contents to C:\MingW  
-
-
-'''13. Compiling PostGIS SVN 1.4 (without shp2pgql-gui)'''  (if you want to install with the GUI you need GTK [UsersWikiWinCompileWithgui Install GTK and PostGIS 1.4 with GUI])
+
+'''14. Compiling PostGIS SVN 1.4 (without shp2pgql-gui)'''  (if you want to install with the GUI you need GTK [UsersWikiWinCompileWithgui Install GTK and PostGIS 1.4 with GUI])
        1. Download postgis.refractions.net/download/postgis-1.4.0.tar.gz and put in C:/thesrc
        2. ''cd /c/thesrc''
@@ -251 +251 @@
        9. ''make check'' [UsersWikiMakeCheckConsiderations Make Check gotchas]
 
-'''14. To use your new postgis'''
+'''15. To use your new postgis'''
        1. copy postgis-1.4.dll from C:\postgresql\lib to your windows PostgreSQL lib folder
        2. copy C:\postgresql\bin\libgeos-3-1-1.dll,libgeos_c-1.dll, libproj.dll, libiconv-2.dll (depending on which version it could be libiconv-2.dll or libiconv2.dll), shp2pgsql.exe, pgsql2shp.exe to your PostgreSQL bin folder