== Compiling using MingGW-w64 for 64-bit == [wiki:UsersWikiWinCompile Back to Compiling in Windows] If you want to get to the last step fast of just compiling PostGIS without having to compile the dependencies, you can download our prepared mingw64 bit chain which you can download from [http://www.bostongis.com/postgisstuff/ming64.zip] , extract to C:\ming64, and launch the c:\ming64\msys\msys.bat and you should be on your way and edit the file in C:\ming64\projects\postgis\builds\makepostgis20w64.sh for testing you'll want to initdb the postgres servers in C:\ming64\projects\pgx64 and then run the start stop scripts. Clicking the batch will start the postgres server and clicking enter will shut it down. With that you can jump straight to the section on compiling PostGIS We are working on similar chain for 32-bit installation. == 1. Installing Minimalist GNU for Windows-w64 (MinGW-w64) == The objective will be to try to use the MingGW-w64 toolchain instead of the standard MingW since it has support for both 32-bit and 64-bit compiling. Details of the prefixes of files can be found at [http://sourceforge.net/apps/trac/mingw-w64/wiki/download%20filename%20structure What to download] MingW-w64 site is [http://mingw-w64.sourceforge.net] * If you are on 64-bit Windows download one of the binary packages from [http://sourceforge.net/projects/mingw-w64/files/Toolchains%20targetting%20Win64/Automated%20Builds/] with name starting with '''mingw-w64-1.0-bin_i686-mingw_''' * If you are on 32-bit Windows download one of the binary packages from [http://sourceforge.net/projects/mingw-w64/files/Toolchains%20targetting%20Win32/Automated%20Builds/] with name starting with '''mingw-w32-1.0-bin_i686-mingw_''' (for my purposes I used mingw-w32-1.0-bin_i686-mingw_20110408.zip) and for native 64-bit (currently using mingw-w64-1.0-bin_i686-mingw_20110516) * Extract your respective zip into a folder called C:\ming64\mingw64 or c:\ming32\mingw32 Geos fails to link if it picks up 32-bit dlls so to overcome this, I copied over the dlls from windows/sytem32 and renamed them as described in #linking errors seems to be caused by as described here [http://www.gaia-gis.it/spatialite-3.0.0-BETA/mingw64_how_to.html#env] mingw64 is picking up the 32-bit dlls from syswow64 instead of the 64-bit dlss from windows/system32 I only needed to copy ws2_32.dll for geos to compile without errors Others may be needed not sure. with windows explorer copy the files from windows/system32 {{{ ws2_32.dll }}} GEOS also gives missing vtable message during link. I think this was caused by msys missing find.exe, so I copied the find.exe from regular msys packaged as instructed in the above link. To your folder: C:\ming64\x86_64-w64-mingw32\lib and then rename them adding a lib extensions so you have {{{ libws2_32.dll # these ones didn't seem necessary for PostGIS: libmsimg32.dll,libgdi32.dll, libcrypt32.dll and libwldap32.dll }}} == 2. Installing Msys == MSys is 32-bit but you can use it with your 32-bit or 64-bit mingw-w64. Instructions are here [http://sourceforge.net/apps/trac/mingw-w64/wiki/MSYS mingw-w64 with MSYS] and repeated here for completeness * download [http://sourceforge.net/projects/mingw-w64/files/External%20binary%20packages%20%28Win64%20hosted%29/MSYS%20%2832-bit%29/ Msys] MSYS-20110309.zip (update there is now a newer MSYS -- MSYS-20110526.zip) * Extract into a folder called C:\Msys * launch msys.bat * type {{{ sh /postinstall/pi.sh }}} When prompted type in {{{C:/ming64/mingw64}}} or {{{C:/ming32/mingw32}}} depending on which tool chain you chose Once done, type logout and the console should exit. == 3a. Installing Autoconf, Automake and Libtool == Relaunch C:\mysy\msys.bat Verify which versions of these you have with autoconf --version etc. If they are not newer (or you get not found) than below then download and install. Download the source code from the GNU site and save to c:\projects * http://ftp.gnu.org/gnu/autoconf/autoconf-2.65.tar.gz * http://ftp.gnu.org/gnu/automake/automake-1.11.1.tar.gz * http://ftp.gnu.org/gnu/libtool/libtool-2.4.tar.gz {{{ cd /c/projects tar -xvf autoconf-2.65.tar.gz cd autoconf-2.65 ./configure --host=x86_64-w64-mingw32 --prefix=/mingw (if you are building for 32-bit then use --host=i686-w64-mingw32) make && make install autoconf --version }}} repeat same exercise for automake For libtool unzip tar -xvf libtool-2.4.10.tar.gz with 7zip into projects folder {{{ cd /c/projects cd libtool-2.4 ./configure --host=x86_64-w64-mingw32 --disable-shared --prefix=/mingw #if you are building on 32-bit then use --host=i686-w64-mingw32 for the host #if you get a message that gcc is not usable, then you probably set your # mingw setting wrong or did not install automake/autotools in /mingw #try to fix by rerunning the sh /postinstall/pi.sh again make clean && make && make install libtool --version }}} == 3.b create project folders == {{{ cd /c/projects mkdir pg mkdir postgresql mkdir geos mkdir proj ls }}} == GDAL == {{{ cd /c/projects mkdir gdal cd gdal wget http://download.osgeo.org/gdal/gdal-1.9.0.tar.gz tar xvfz gdal-1.9.0.tar.gz cd gdal-1.9.0 ./configure --host=x86_64-w64-mingw32 --build=x86_64-w64-mingw32 --with-threads=no --prefix=/c/projects/gdal/rel-1.9.0w64 make && make install cd /c/projects/gdal/rel-1.9.0w64/bin strip *.dll }}} == 4. Compiling GEOS == Download latest GEOS source from http://trac.osgeo.org/geos/ either the http://download.osgeo.org/geos/geos-3.3.2.tar.bz2 You can also use the trunk svn version https://svn.osgeo.org/geos/trunk. If you are using svn version, make sure to run: {{{ sh autogen.sh }}} this fails at linker phase with a whole bunch of errors if you compile without doing #linking errors seems to be caused by as described here [http://www.gaia-gis.it/spatialite-3.0.0-BETA/mingw64_how_to.html#env] mingw64 is picking up the 32-bit dlls from syswow64 instead of the 64-bit dlss from windows/system32 I may have over-copied, but to remedy before evening starting configure with windows explorer copy the files from windows/system32 {{{ ws2_32.dll, kernel32.dll, advapi32.dll, mscvrt.dll, user32.dll }}} To your folder: C:\mingw\mingw64\x86_64-w64-mingw32\lib and then rename them adding a lib extensions so you have {{{ libws2_32.dll, libkernel32.dll, libadvapi32.dll, libmscvrt.dll, libuser32.dll }}} # hack described in [http://www.gaia-gis.it/spatialite-3.0.0-BETA/mingw64_how_to.html#libgeos] {{{ simplify/.libs/libsimplify.a(TopologyPreservingSimplifier.o):TopologyPreservingS implifier.cpp:(.rdata+0x1f0): undefined reference to `geos::geom::util::GeometryTransformer::transformGeometryCollection(geos::geom::GeometryCollection const*, geos::geom::Geometry const*)' and bunch of other classes in util::GeometryTransformer.. the .la file gets created so seems to be at linker phase. }}} -- follow instructions in [http://www.gaia-gis.it/spatialite-3.0.0-BETA/mingw64_how_to.html#libgeos] {{{ cd /c/projects/geos tar xjf geos-3.3.3.tar.bz2 cd geos-3.3.3 ./configure --build=x86_64-w64-mingw32 --host=x86_64-w64-mingw32 --prefix=/c/projects/geos/rel-3.3.3w64 | tee /c/geos_configure_3.3.log make make install }}} To strip all the debug info weight from the libgeos DLL files, run {{{ strip /c/projects/bin/geos/rel-3.3.3/*.dll }}} == Installing !LibIconv == For iconv we are going to compile our own copy instead of installing from GNUWin. * http://ftp.gnu.org/gnu/libiconv/libiconv-1.13.1.tar.gz Save the source in your C:\ming64\projects directory. Open up the MSYS terminal. Ignore the errors in the configure process. {{{ cd /c/projects tar xvfz libiconv-1.13.1.tar.gz cd libiconv-1.13.1 ./configure --host=x86_64-w64-mingw32 --build=x86_64-w64-mingw32 --target=x86_64-w64-mingw32 --prefix=/c/projects/rel-libiconv-1.13.1w64 make make install }}} Copy rel-.. contents int c:\mingw\mingw64 folder. For some reason using libiconv-prefix did not work for configuring postgis. Verify if the version of iconv you are running is the same as the one you just compiled (1.13): {{{ # iconv --version }}} == Compiling Proj == Download Proj4 from the web site, and the datum shifts grid file. * http://download.osgeo.org/proj/proj-4.8.0.tar.gz * http://download.osgeo.org/proj/proj-datumgrid-1.5.zip and copy to c:\projects\proj The datum grid file must be unzipped into the "nad" subdirectory of the Proj4 source tree. {{{ #set this to whereever you plan to keep your source #I have one for 32-bit and one for 64-bit export PROJECTS=/c/ming64/projects cd /c/${PROJECTS}/proj wget http://download.osgeo.org/proj/proj-4.8.0.tar.gz wget http://download.osgeo.org/proj/proj-datumgrid-1.5.zip tar xvfz proj-4.8.0.tar.gz cd proj-4.8.0 cd nad unzip ../../proj-datumgrid-1.5.zip cd .. ./configure --prefix=${PROJECTS}/proj/rel-4.8.0w64 --host=x86_64-w64-mingw32 --enable-shared make clean make && make install }}} == Compiling and Installing C-Unit == Download from http://sourceforge.net/projects/cunit/ into c:\projects {{{ cd /c/projects wget http://iweb.dl.sourceforge.net/project/cunit/CUnit/2.1-2/CUnit-2.1-2-src.tar.bz2 tar -xvf CUnit-2.1-2-src.tar.bz2 cd CUnit-2.1.2 #if you are building for 64-bit then use x86_64-w64-mingw32 for the build,host,target #32 bit uses i686-w64-mingw32 for build, host, target ./configure --host=x86_64-w64-mingw32 --prefix=/mingw make && make install }}} For some reason, PostGIS couldn't find my cunit install. So I had to copy the files: from C:\ming64\mingw64\include\CUnit to C:\ming64\mingw64\x86_64-w64-mingw32\include\CUnit == 7. Compiling LibXML2 == {{{ mkdir /c/projects/libxml cd /c/projects/libxml wget ftp://xmlsoft.org/libxml2/libxml2-2.7.8.tar.gz }}} {{{ tar xvfz libxml2-2.7.8.tar.gz cd libxml2-2.7.8 #if you are building for 64-bit then use x86_64-w64-mingw32 for the build,host,target #32 bit uses i686-w64-mingw32 for build, host, target ./configure --prefix=/c/projects/libxml/rel-libxml2-2.7.8w64 --build=x86_64-w64-mingw32 --host=x86_64-w64-mingw32 --target=x86_64-w64-mingw32 --enable-shared --with-threads=no CFLAGS=-O2 #Note to self: used to have CCFLAGS=LDFLAGS="-Wl,-static" in here will see how it goes without #If you have pthreads installed, libxml picks it up and royally screws up thus the need for --with-threads=no make make install }}} You might get an error during the configure process {{{ /bin/rm: cannot lstat `libtoolT': No such file or directory }}} That error seems safe to ignore. == 8. Compiling PostgreSQL 9.1 == Download source from: [http://ftp.postgresql.org/pub/source/v9.1.3/postgresql-9.1.3.tar.bz2] {{{ mkdir /c/projects/pgx64 cd postgresql tar -xvjf postgresql-9.1.3.tar.bz2 cd postgresql-9.1.3 #if you are building for 64-bit then use x86_64-w64-mingw32 for the build,host,target #32 bit uses i686-w64-mingw32 for build, host, target #EnterpriseDb VC++ 64-bit builds are compiled with disable float8 by val. #If we don't include this line, the modules compiled against mingw64 will be incompatible with edb builds ./configure --prefix=/c/projects/pgx64/pg91 \ --build=x86_64-w64-mingw32 \ --host=x86_64-w64-mingw32 --target=x86_64-w64-mingw32 \ --with-pgport=5441 --enable-cassert --enable-debug \ --enable-integer-datetimes --disable-float8-byval --without-zlib make make install #initialize the database cluster /c/projects/pgx64/pg91/bin/initdb -U postgres -D /c/projects/pgx64/pg91/data -A trust }}} == Compiling JSON-C == This is needed if you want ST_GeomFromGeoJSON to be functional. Download [http://oss.metaparadigm.com/json-c/json-c-0.9.tar.gz] and save to c:\projects\json-c {{{ cd /c/projects/json-c tar xvfz json-c-0.9.tar.gz cd json-c-0.9 ## had to compile with -w (disable warnings otherwise it gave errors ./configure --build=x86_64-w64-mingw32 \ --host=x86_64-w64-mingw32 --target=x86_64-w64-mingw32 \ --prefix=/c/projects/json-c/rel-0.9w64 CFLAGS=-w make clean make make install }}} == Copy over needed dlls to PostgreSQL folders == {{{ export PATHOLD=$PATH export PATH=$PATH:/c/projects/pgx64/pg91edb/bin:/mingw export PGHOST=localhost export PGPORT=5441 export PGUSER=postgres cp /c/projects/geos/rel-3.3.3w64/bin/*.dll /c/projects/pgx64/pg91edb/bin cp /c/projects/gdal/rel-1.9.0w64/bin/*.dll /c/projects/pgx64/pg91edb/bin cp /c/projects/proj/rel-4.7.0w64/bin/*.dll /c/projects/pgx64/pg91edb/bin cp /c/mingw/mingw64/bin/libgcc_s_sjlj-1.dll /c/projects/pgx64/pg91edb/bin cp /c/projects/geos/rel-3.3.3w64/bin/*.dll /c/projects/pgx64/pg91/bin cp /c/projects/gdal/rel-1.9.0w64/bin/*.dll /c/projects/pgx64/pg91/bin cp /c/projects/proj/rel-4.7.0w64/bin/*.dll /c/projects/pgx64/pg91/bin cp /c/mingw/mingw64/bin/libgcc_s_sjlj-1.dll /c/projects/pgx64/pg91/bin }}} == Getting GTK == If you want to build the shp2pgsql-gui loader in 64-bit, you can use the pre-compiled gtk bundle which already has the needed headers {{{ export PORJECTS=/c/ming64/projects/gtk cd ${PROJECTS} mkdir gtk cd gtk wget http://ftp.gnome.org/pub/gnome/binaries/win64/gtk+/2.22/gtk+-bundle_2.22.1-20101229_win64.zip unzip gtk+-bundle_2.22.1-20101229_win64.zip }}} == Compiling PostGIS 2.0 == * There is a problem at least for my Mingw64 that prevents functions like ST_AsText and ST_AsKML that makes it leave out digits randomly * This also causes issues for shp2pgsql. The issue is the fact that the MingW64 chain uses * Microsoft's vsprintf version instead of the C99 one. This version when space is not enough returns an error code instead of length of output the write * To work around this issue, I put in this pretty ugly hack in the liblwgeom/string_buffer.c around line 210 change: {{{ if ( len < 0 ) return len; }}} to: {{{ if ( len < 0 ) len = _vscprintf(fmt, ap2); }}} Details of this issue are outlined in #1668 {{{ export PROJECTS=/c/ming64/projects export PG_VER=91 export PGWINVER=${PG_VER}edb # had to override the paths since cunit was picking up 32-bit junk and crashing export PATHOLD=".:/bin:/include:/mingw/bin:/mingw/include:/c/Windows/system32:/c/Windows:/c/ming64/mingw64/include" export PATH="${PATHOLD}:${PROJECTS}/pgx64/pg${PG_VER}/bin:${PROJECTS}/pgx64/pg${PG_VER}/lib" #needed to build comments and shp2pgsql-gui export PATH="${PATH}:${PROJECTS}/xsltproc:${PROJECTS}/gtk/bin" export POSTGIS_SRC=${PROJECTS}/postgis/postgis-${POSTGIS_MICRO_VER} cd /c/ming64/projects mkdir postgis cd postgis wget http://www.postgis.org/download/postgis-${POSTGIS_MICRO_VER}.tar.gz tar xvf postgis-${POSTGIS_MICRO_VER}.tar.gz cd ${POSTGIS_SRC} CPPFLAGS="-I${PROJECTS}/pgx64/pg${PG_VER}/include -I${PROJECTS}/gettextrel-gettext-0.18.1/include -I${PROJECTS}/rel-libiconv-1.13.1w64/include" \ LDFLAGS="-L${PROJECTS}/pgx64/pg${PG_VER}/lib -L${PROJECTS}/gdal/rel-${GDAL_VER}/lib -L${PROJECTS}/gettext/rel-gettext-0.18.1/lib -L${PROJECTS}/rel-libiconv-1.13.1w64/lib" ./configure \ --build=x86_64-w64-mingw32 \ --with-xml2config=${PROJECTS}/libxml/rel-libxml2-2.7.8w64/bin/xml2-config \ --with-pgconfig=${PROJECTS}/pgx64/pg${PG_VER}/bin/pg_config \ --with-geosconfig=${PROJECTS}/geos/rel-${GEOSVER}/bin/geos-config \ --with-projdir=${PROJECTS}/proj/rel-4.7.0w64 \ --with-gdalconfig=${PROJECTS}/gdal/rel-${GDAL_VER}/bin/gdal-config \ --with-jsondir=${PROJECTS}/json-c/rel-0.9w64 \ --with-libiconv=${PROJECTS}/rel-libiconv-1.13.1w64 \ --with-gui --with-gettext=no }}} #this part is a hack, but again didn't work without it #you can try without doing this, but if you get errors about # conflicting type def boolean during PostGIS compile, you need this. #In my case I got this: {{{ In file included from c:/ming64/projects/json-c/rel-0.9w64/include/json/json_util.h:1 from c:/projects/json-c/rel-0.9w64/include/json/json.h:23, from lwgeom_in_geojson.c:31: c:/ming64/projects/json-c/rel-0.9w64/include/json/json_object.h:32: error: conflictin types for 'boolean' c:\mingw\mingw64\bin\../lib/gcc/x86_64-w64-mingw32/4.4.7/../../../../x86_64-w6 mingw32/include/rpcndr.h:52: note: previous declaration of 'boolean' was here make[1]: *** [lwgeom_in_geojson.o] Error 1 }}} * Open up /c/projects/json-c/rel-0.9/include/json/json_object.h * remark out line 32 that reads {{{ typedef int boolean }}} * so it should now read {{{ /** typedef int boolean; **/ }}} * During the PostGIS configure process, you have to put this back the way it was otherwise configure complains json.h or something is not usable and refuses to configure with JSON-C support. Then you remark the line out again during compile. Crazy I know, but json-c won't compile without that line so can't take it out before json-c compile. If you run into problems with your build, pipe the output into a file for further analysis. The GUI requires that pkg-config be on your PATH, check that it is there by running 'which pkg-config'. {{{ make 2>&1 | tee /c/build.log make check make install }}}