Installation on windows 64 failed

[pierrevandelaar]

I tried to install PostGIS 2.0.0 release for PostgreSQL 9.1 64-bit (inc. GEOS 3.3.3/PROJ 4.8.0/GDAL 1.9.0 ~18Mb) using the windows installer.

This lead to the error reported in file 'create_templatepostgis_sql_error.txt': ERROR: could not load library "C:/Program Files/PostgreSQL/9.1/lib/postgis-2.0.dll": The specified module could not be found.

—details ——————————————— Output folder: C:\Users\<name>\AppData\Local\Temp\postgis_installer Installer running on 64-bit host UserName=postgres Password=xxxx Port=5432 Checking for existing PostGIS installation… Removing existing template_postgis_20 database… <due to rerun to regenerate error message> Output folder: C:\Program Files\PostgreSQL\9.1\bin Extract: libgcc_s_sjlj-1.dll… 100% Extract: libgdal-1.dll… 100% Extract: libgeos-3-3-3.dll… 100% Extract: libgeos_c-1.dll… 100% Extract: libproj-0.dll… 100% Extract: libstdc++-6.dll… 100% Extract: pgsql2shp.exe… 100% Extract: raster2pgsql.exe… 100% Extract: shp2pgsql.exe… 100% Skipped: libxml2-2.dll Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui Extract: freetype-config… 100% Extract: gettext.sh… 100% Extract: glib-gettextize… 100% Extract: glib-mkenums… 100% Extract: gtk-builder-convert… 100% Extract: gtk-update-icon-cache.exe.manifest… 100% Extract: libasprintf-0.dll… 100% Extract: libatk-1.0-0.dll… 100% Extract: libcairo-2.dll… 100% Extract: libcairo-gobject-2.dll… 100% Extract: libcairo-script-interpreter-2.dll… 100% Extract: libeay32.dll… 100% Extract: libexpat-1.dll… 100% Extract: libfontconfig-1.dll… 100% Extract: libfreetype-6.dll… 100% Extract: libgailutil-18.dll… 100% Extract: libgcc_s_sjlj-1.dll… 100% Extract: libgdk-win32-2.0-0.dll… 100% Extract: libgdk_pixbuf-2.0-0.dll… 100% Extract: libgio-2.0-0.dll… 100% Extract: libglib-2.0-0.dll… 100% Extract: libgmodule-2.0-0.dll… 100% Extract: libgobject-2.0-0.dll… 100% Extract: libgthread-2.0-0.dll… 100% Extract: libgtk-win32-2.0-0.dll… 100% Extract: libiconv-2.dll… 100% Extract: libintl-8.dll… 100% Extract: libpango-1.0-0.dll… 100% Extract: libpangocairo-1.0-0.dll… 100% Extract: libpangoft2-1.0-0.dll… 100% Extract: libpangowin32-1.0-0.dll… 100% Extract: libpng14-14.dll… 100% Extract: libpq.dll… 100% Extract: shp2pgsql-gui.exe… 100% Extract: ssleay32.dll… 100% Extract: zlib1.dll… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\etc\fonts Extract: fonts.conf… 100% Extract: fonts.dtd… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\etc\gtk-2.0 Extract: gtkrc… 100% Extract: im-multipress.conf… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\etc\pango Extract: pango.modules… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\lib Extract: atk-1.0.def… 100% Extract: atk-1.0.lib… 100% Extract: cairo.def… 100% Extract: cairo.lib… 100% Extract: expat.lib… 100% Extract: fontconfig.def… 100% Extract: fontconfig.lib… 100% Extract: freetype.def… 100% Extract: freetype.lib… 100% Extract: gailutil.lib… 100% Extract: gdk-win32-2.0.lib… 100% Extract: gdk_pixbuf-2.0.lib… 100% Extract: gio-2.0.def… 100% Extract: gio-2.0.lib… 100% Extract: glib-2.0.def… 100% Extract: glib-2.0.lib… 100% Extract: gmodule-2.0.def… 100% Extract: gmodule-2.0.lib… 100% Extract: GNU.Gettext.dll… 100% Extract: gobject-2.0.def… 100% Extract: gobject-2.0.lib… 100% Extract: gthread-2.0.def Extract: gthread-2.0.lib… 100% Extract: gtk-win32-2.0.lib… 100% Extract: intl.lib… 100% Extract: libasprintf.dll.a… 100% Extract: libatk-1.0.dll.a… 100% Extract: libcairo-gobject.dll.a… 100% Extract: libcairo-script-interpreter.dll.a… 100% Extract: libcairo.dll.a… 100% Extract: libexpat.def… 100% Extract: libexpat.dll.a… 100% Extract: libfontconfig.dll.a… 100% Extract: libfreetype.dll.a… 100% Extract: libgailutil.dll.a… 100% Extract: libgdk-win32-2.0.dll.a… 100% Extract: libgdk_pixbuf-2.0.dll.a… 100% Extract: libgio-2.0.dll.a… 100% Extract: libglib-2.0.dll.a… 100% Extract: libgmodule-2.0.dll.a… 100% Extract: libgobject-2.0.dll.a… 100% Extract: libgthread-2.0.dll.a… 100% Extract: libgtk-win32-2.0.dll.a… 100% Extract: libintl.def… 100% Extract: libintl.dll.a… 100% Extract: libpango-1.0.dll.a… 100% Extract: libpangocairo-1.0.dll.a… 100% Extract: libpangoft2-1.0.dll.a… 100% Extract: libpangowin32-1.0.dll.a… 100% Extract: libpixman-1.a… 100% Extract: libpng.def… 100% Extract: libpng.lib… 100% Extract: libpng14.dll.a… 100% Extract: libz.dll.a… 100% Extract: pango-1.0.def… 100% Extract: pango-1.0.lib… 100% Extract: pangocairo-1.0.def… 100% Extract: pangocairo-1.0.lib… 100% Extract: pangoft2-1.0.def… 100% Extract: pangoft2-1.0.lib… 100% Extract: pangowin32-1.0.def… 100% Extract: pangowin32-1.0.lib… 100% Extract: zdll.lib… 100% Extract: zlib.def… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\lib\gdk-pixbuf-2.0\2.10.0 Extract: loaders.cache… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\lib\glib-2.0\include Extract: glibconfig.h… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\lib\gtk-2.0\2.10.0\engines Extract: libpixmap.dll… 100% Extract: libwimp.dll… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\lib\gtk-2.0\include Extract: gdkconfig.h… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\lib\gtk-2.0\modules Extract: libgail.dll… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\lib\pkgconfig Extract: atk.pc… 100% Extract: cairo-fc.pc… 100% Extract: cairo-ft.pc… 100% Extract: cairo-gobject.pc… 100% Extract: cairo-pdf.pc… 100% Extract: cairo-png.pc… 100% Extract: cairo-ps.pc… 100% Extract: cairo-svg.pc… 100% Extract: cairo-win32-font.pc… 100% Extract: cairo-win32.pc… 100% Extract: cairo.pc… 100% Extract: fontconfig.pc… 100% Extract: freetype2.pc… 100% Extract: gail.pc… 100% Extract: gdk-2.0.pc… 100% Extract: gdk-pixbuf-2.0.pc… 100% Extract: gdk-win32-2.0.pc… 100% Extract: gio-2.0.pc… 100% Extract: gio-windows-2.0.pc… 100% Extract: glib-2.0.pc… 100% Extract: gmodule-2.0.pc… 100% Extract: gmodule-no-export-2.0.pc… 100% Extract: gobject-2.0.pc… 100% Extract: gthread-2.0.pc… 100% Extract: gtk+-2.0.pc… 100% Extract: gtk+-win32-2.0.pc… 100% Extract: libpng.pc… 100% Extract: libpng14.pc… 100% Extract: pango.pc… 100% Extract: pangocairo.pc… 100% Extract: pangoft2.pc… 100% Extract: pangowin32.pc… 100% Extract: pixman-1.pc… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\share\themes\Default\gtk-2.0-key Extract: gtkrc… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\share\themes\Default\gtk-2.0-key-old Extract: gtkrc Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\share\themes\Emacs\gtk-2.0-key Extract: gtkrc… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\share\themes\MS-Windows\gtk-2.0 Extract: gtkrc… 100% Output folder: C:\Program Files\PostgreSQL\9.1\bin\postgisgui\share\themes\Raleigh\gtk-2.0 Extract: gtkrc… 100% Output folder: C:\Program Files\PostgreSQL\9.1\doc\contrib Extract: postgis-2.0.pdf… 100% Output folder: C:\Program Files\PostgreSQL\9.1\gdal-data Extract: compdcs.csv… 100% Extract: coordinate_axis.csv… 100% Extract: cubewerx_extra.wkt… 100% Extract: datum_shift.csv… 100% Extract: ecw_cs.wkt… 100% Extract: ellipsoid.csv… 100% Extract: epsg.wkt… 100% Extract: esri_extra.wkt… 100% Extract: esri_StatePlane_extra.wkt… 100% Extract: esri_Wisconsin_extra.wkt… 100% Extract: gcs.csv… 100% Extract: gcs.override.csv… 100% Extract: gdalicon.png Extract: GDALLogoBW.svg… 100% Extract: GDALLogoColor.svg… 100% Extract: GDALLogoGS.svg… 100% Extract: gdal_datum.csv… 100% Extract: geoccs.csv… 100% Extract: gt_datum.csv… 100% Extract: gt_ellips.csv… 100% Extract: header.dxf… 100% Extract: nitf_spec.xml… 100% Extract: nitf_spec.xsd… 100% Extract: pci_datum.txt… 100% Extract: pci_ellips.txt… 100% Extract: pcs.csv… 100% Extract: pcs.override.csv… 100% Extract: prime_meridian.csv… 100% Extract: projop_wparm.csv… 100% Extract: s57agencies.csv… 100% Extract: s57attributes.csv… 100% Extract: s57attributes_aml.csv… 100% Extract: s57attributes_iw.csv… 100% Extract: s57expectedinput.csv… 100% Extract: s57objectclasses.csv… 100% Extract: s57objectclasses_aml.csv… 100% Extract: s57objectclasses_iw.csv… 100% Extract: seed_2d.dgn… 100% Extract: seed_3d.dgn… 100% Extract: stateplane.csv… 100% Extract: trailer.dxf… 100% Extract: unit_of_measure.csv… 100% Extract: vertcs.csv… 100% Extract: vertcs.override.csv… 100% Output folder: C:\Program Files\PostgreSQL\9.1\lib Extract: postgis-2.0.dll… 100% Extract: rtpostgis-2.0.dll… 100% Output folder: C:\Program Files\PostgreSQL\9.1\pgAdmin III\plugins.d Extract: postgis.shp2pgsql-gui.ini… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0 Extract: legacy.sql… 100% Extract: legacy_compatibility_layer.sql… 100% Extract: legacy_minimal.sql… 100% Extract: postgis.sql… 100% Extract: postgis_comments.sql… 100% Extract: postgis_upgrade_20_minor.sql… 100% Extract: raster_comments.sql… 100% Extract: rtpostgis.sql… 100% Extract: rtpostgis_legacy.sql… 100% Extract: rtpostgis_upgrade_20_minor.sql… 100% Extract: spatial_ref_sys.sql… 100% Extract: uninstall_legacy.sql… 100% Extract: uninstall_postgis.sql… 100% Extract: uninstall_rtpostgis.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\history_table Extract: history_table.sql… 100% Extract: README… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\ogc_test_suite Extract: 1_schema.sql… 100% Extract: 2_queries.sql… 100% Extract: 3_cleanup.sql… 100% Extract: Makefile… 100% Extract: README… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\rpm Extract: README… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\rpm\patches Extract: filter-requires-perl-Pg.sh Extract: postgis-configure.patch… 100% Extract: postgis-javamakefile.patch… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\rpm\spec Extract: postgis.spec… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\template_gis Extract: createdb.postgis.1… 100% Extract: createdb.postgis.in… 100% Extract: Makefile… 100% Extract: mktemplate_gis.1… 100% Extract: mktemplate_gis.in… 100% Extract: mktemplate_gis.sh.in… 100% Extract: postgis_env.sh.in… 100% Extract: postgres_lib.sh.in… 100% Extract: profile… 100% Extract: README… 100% Extract: rmtemplate_gis.1… 100% Extract: rmtemplate_gis.in… 100% Extract: rmtemplate_gis.sh.in… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder Extract: README… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2006andbefore Extract: create_geocode.sql… 100% Extract: INSTALL… 100% Extract: README… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2006andbefore\geocode Extract: geocode.sql… 100% Extract: geocode_address.sql… 100% Extract: geocode_address_countysub_exact.sql… 100% Extract: geocode_address_countysub_fuzzy.sql… 100% Extract: geocode_address_place_exact.sql… 100% Extract: geocode_address_place_fuzzy.sql… 100% Extract: geocode_address_state.sql… 100% Extract: geocode_address_zip.sql… 100% Extract: geocode_get_point.sql… 100% Extract: geocode_location.sql… 100% Extract: geocode_zip.sql… 100% Extract: includes_address.sql… 100% Extract: interpolate_from_address.sql… 100% Extract: rate_attributes.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2006andbefore\import Extract: load_tiger.sh… 100% Extract: newdb.sh… 100% Extract: tigerimport.sh… 100% Extract: tigerpoly2.py… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2006andbefore\normalize Extract: count_words.sql… 100% Extract: end_soundex.sql… 100% Extract: get_last_words.sql… 100% Extract: location_extract.sql… 100% Extract: location_extract_countysub_exact.sql… 100% Extract: location_extract_countysub_fuzzy.sql… 100% Extract: location_extract_place_exact.sql… 100% Extract: location_extract_place_fuzzy.sql… 100% Extract: normalize_address.sql… 100% Extract: pprint_addy.sql… 100% Extract: state_extract.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2006andbefore\orig Extract: tiger_geocoder.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2006andbefore\tables Extract: lookup_tables.sql… 100% Extract: roads_local.sql… 100% Extract: tiger_geocode_roads.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2006andbefore\utility Extract: cull_null.sql… 100% Extract: levenshtein_ignore_case.sql… 100% Extract: nullable_levenshtein.sql… 100% Extract: utmzone.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2010 Extract: census_loader.sql… 100% Extract: create_geocode.bat… 100% Extract: create_geocode.sh… 100% Extract: create_geocode.sql… 100% Extract: README… 100% Extract: tiger_loader.sql… 100% Extract: upgrade_geocode.sql… 100% Extract: upgrade_geocoder.bat… 100% Extract: upgrade_geocoder.sh… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2010\geocode Extract: census_tracts_functions.sql… 100% Extract: geocode.sql… 100% Extract: geocode_address.sql… 100% Extract: geocode_intersection.sql… 100% Extract: geocode_location.sql… 100% Extract: includes_address.sql… 100% Extract: interpolate_from_address.sql… 100% Extract: other_helper_functions.sql… 100% Extract: rate_attributes.sql… 100% Extract: reverse_geocode.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2010\legacy_import\tiger2008 Extract: import_tiger_shps.sh… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2010\normalize Extract: count_words.sql… 100% Extract: end_soundex.sql… 100% Extract: get_last_words.sql… 100% Extract: location_extract.sql… 100% Extract: location_extract_countysub_exact.sql… 100% Extract: location_extract_countysub_fuzzy.sql… 100% Extract: location_extract_place_exact.sql… 100% Extract: location_extract_place_fuzzy.sql… 100% Extract: normalize_address.sql… 100% Extract: pprint_addy.sql… 100% Extract: state_extract.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2010\regress Extract: geocode_regress… 100% Extract: geocode_regress.sql… 100% Extract: normalize_address_regress… 100% Extract: normalize_address_regress.sql… 100% Extract: regress.sql… 100% Extract: reverse_geocode_regress… 100% Extract: reverse_geocode_regress.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2010\tables Extract: lookup_tables_2010.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2010\topology Extract: README… 100% Extract: tiger_topology_loader.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2010\utility Extract: cull_null.sql… 100% Extract: levenshtein_ignore_case.sql… 100% Extract: nullable_levenshtein.sql… 100% Extract: utmzone.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\WFS_locks Extract: Makefile… 100% Extract: README… 100% Extract: test.sql… 100% Extract: WFS_locks.c… 100% Extract: WFS_locks.sql.in… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\extras\wkb_reader Extract: Makefile… 100% Extract: printwkb.c… 100% Extract: README… 100% Extract: readwkb.c… 100% Extract: wkbtest.h… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\proj Extract: alaska… 100% Extract: conus… 100% Extract: epsg… 100% Extract: esri… 100% Extract: esri.extra… 100% Extract: FL… 100% Extract: GL27… 100% Extract: hawaii… 100% Extract: IGNF… 100% Extract: MD… 100% Extract: nad.lst… 100% Extract: nad27… 100% Extract: nad83… 100% Extract: ntf_r93.gsb… 100% Extract: ntv1_can.dat… 100% Extract: null… 100% Extract: nzgd2kgrid0005.gsb… 100% Extract: other.extra… 100% Extract: proj_def.dat… 100% Extract: prvi… 100% Extract: stgeorge… 100% Extract: stlrnc… 100% Extract: stpaul… 100% Extract: TN… 100% Extract: WI… 100% Extract: WO… 100% Extract: world… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\contrib\postgis-2.0\topology Extract: topology.sql… 100% Extract: topology_comments.sql… 100% Extract: topology_upgrade_20_minor.sql… 100% Extract: uninstall_topology.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\share\extension Extract: postgis—2.0.0.sql… 100% Extract: postgis—2.0.0alpha1—2.0.0.sql… 100% Extract: postgis—2.0.0alpha2—2.0.0.sql… 100% Extract: postgis—2.0.0alpha3—2.0.0.sql… 100% Extract: postgis—2.0.0alpha4—2.0.0.sql… 100% Extract: postgis—2.0.0alpha5—2.0.0.sql… 100% Extract: postgis—2.0.0alpha6—2.0.0.sql… 100% Extract: postgis—2.0.0beta1—2.0.0.sql… 100% Extract: postgis—2.0.0beta2—2.0.0.sql… 100% Extract: postgis—2.0.0beta3—2.0.0.sql… 100% Extract: postgis—2.0.0beta4—2.0.0.sql… 100% Extract: postgis—2.0.0rc1—2.0.0.sql… 100% Extract: postgis—2.0.0rc2—2.0.0.sql… 100% Extract: postgis—unpackaged—2.0.0.sql… 100% Extract: postgis.control… 100% Extract: postgis.sql… 100% Extract: postgis_topology—2.0.0.sql… 100% Extract: postgis_topology—2.0.0alpha1—2.0.0.sql… 100% Extract: postgis_topology—2.0.0alpha2—2.0.0.sql… 100% Extract: postgis_topology—2.0.0alpha3—2.0.0.sql… 100% Extract: postgis_topology—2.0.0alpha4—2.0.0.sql… 100% Extract: postgis_topology—2.0.0alpha5—2.0.0.sql… 100% Extract: postgis_topology—2.0.0alpha6—2.0.0.sql… 100% Extract: postgis_topology—2.0.0beta1—2.0.0.sql… 100% Extract: postgis_topology—2.0.0beta2—2.0.0.sql… 100% Extract: postgis_topology—2.0.0beta3—2.0.0.sql… 100% Extract: postgis_topology—2.0.0beta4—2.0.0.sql… 100% Extract: postgis_topology—2.0.0rc1—2.0.0.sql… 100% Extract: postgis_topology—2.0.0rc2—2.0.0.sql… 100% Extract: postgis_topology—unpackaged—2.0.0.sql… 100% Extract: postgis_topology.control… 100% Extract: postgis_topology.sql… 100% Output folder: C:\Program Files\PostgreSQL\9.1\utils Extract: create_undef.pl… 100% Extract: Makefile… 100% Extract: Makefile.in… 100% Extract: postgis_proc_upgrade.pl… 100% Extract: postgis_restore.pl… 100% Extract: postgis_restore.pl.in… 100% Extract: profile_intersects.pl… 100% Extract: README… 100% Extract: read_scripts_version.pl… 100% Extract: svn_repo_revision.pl… 100% Extract: test_estimation.pl… 100% Extract: test_geography_estimation.pl… 100% Extract: test_geography_joinestimation.pl… 100% Extract: test_joinestimation.pl… 100% Extract: uninstall_script… 100% Creating template database… Loading PLPGSQL language… Loading PostGIS functions… ExecShell: open C:\Users\<name>\AppData\Local\Temp\postgis_installer\create_templatepostgis_sql_error.txt Database installation of PostGIS functions failed Database installation of PostGIS functions failed

---

I hypothesize that it is related to The installation of libxml2-2.dll in C:\Program Files\PostgreSQL\9.1\bin. Which needs libiconv-2.dll which is installed in C:\Program Files\PostgreSQL\9.1\bin\postgisgui. However libxml2-2.dll doesn't seem to be able to find libiconv-2.dll

[robe]

Pierre,

the postgisgui folder is a self-contained set of libraries for running the shp2pgsql-gui loader/dumper. It intentionally has some redundant files.

Can you tell me which version of PostgreSQL you are running. Do a

SELECT version();

Also where you got your installer from. Someone posted a similar issue and that they were running with an installer they got from ESRI.

​http://postgis.refractions.net/pipermail/postgis-users/2012-May/034124.html

did you try dependency walker as notied to see what else could be missing

also which version of windows are you running on?

Thanks, Regina

[robe]

additional note — if you are missing libiconv-2.dll in postgresql/9.1/bin then that could be the problem. You should be able to just copy the one from postgisgui into the bin folder. We didn't bother packaging that one since EnterpriseDb builds we were targetting already had that file in bin.

[pierrevandelaar]

hi robe,

I already tried copying that dll. It did not help. Replacing lib xml 2-2 by xml 2, did solve the problem. I will mail the requested details on Monday when I am at work.

Pierre

From my tablet.

[pierrevandelaar]

The Windows version is: Windows 7 Enterprise Service Pack 1 64 bits

The PostgreSQL version is: PostgreSQL 9.1.2, compiled by Visual C++ build 1500, 64-bit

The installer was downloaded from: ​http://www.postgis.org/download/windows/pg91/postgis-pg91x64-setup-2.0.0-4.exe

We observed that zlib1.dll in C:\Program Files\PostgreSQL\9.1\bin\postgisgui is version 1.2.5.0 while in C:\Program Files\PostgreSQL\9.1\bin the version is 1.2.2.0

The 1.2.2.0 version does not work with the libxml dll from the postgisgui directory; it is missing the 'gzdirect' symbol (according to dependency walker). Can we just overwrite it with the 1.2.5.0 version or will that break the postgreSQL server?

[robe]

You might want to just upgrade to 9.1.3 and that might fix your issue. I think between 9.1.2 and 9.1.3 they changed names they started using libxml2-2 instead of libxml2. Anyrate you should upgrade regardless since you aren't runnign the latest micro.

[robe]

one more note — the files in postgisgui folder are completely independent of the ones used by postgresql except for the libpq.dll. Most of the postgis-gui files come straight from gtk and we packaged them in a separate folder so as not to conflict with the ones in the postgresql bin folder. ​ftp://ftp.gnome.org/pub/gnome/binaries/win64/gtk+/2.22/

Libraries like libxml allow you to add in a lot of additional includes so that the fact they are different is not surprising since PostgreSQL folks probably needed different features enabled beyond the base. That is also why the zlibs are different since we packaged the one that came with gtk in the postgisgui folder. So in short that folder is meant to run as a self-contained unit. You can move it anywhere and it will still work.

[pierrevandelaar]

I upgraded to PostgresQL 9.1.3. The installation of PostGIS 2.0.0 then went fine. Problem solved Maybe add a note to the installation instructions that you need 9.1.3….

[robe]

I thought we had fixed the issue, but I guess not. I'll put a note on the website site. Unfortunately anyone installing from stackbuilder is not going to read it. I thought we were packaging the libxml2-2.dll so that it would install on 9.1.2 and 9.0.5, but was hard to test since we don't have those versions installed. I suspect that's a similar issue the ESRI folks are running into since I think ESRI packages with 9.0.5 (instead of 9.0.6) which has the same issue as 9.1.2.

Anway thanks for the report. Goes a long way to helping others with similar issue.

[tastle]

Hi all,

I just installed Postgres 9.1.6 Windows x64. Then I installed PostGIS 2.0.1 for pg 91 x64 and I get the same error as above. "ERROR: could not load library "C:/Program Files/PostgreSQL/9.1/lib/postgis-2.0.dll": %1 is not a valid Win32 application."

I didn't quite follow the resolution in the steps above. How do I go about this?

[robe]

tastle,

I haven't tested 9.1.6 since I'm running 9.2x64 in production. The issue is usually with the libxml2-2.dll. They may have upgraded their libxml version or changed the name again. Ah the bain of my existence.

If you have a libxml2.dll, try copying over to libxml2-2.dll and see if that solves your problem.

How did you install? did you use stackbuilder or just the zip file? This issue happens also if you accidentally pulled the 32-bit dlls instead of the 64-bit ones.

[tastle]

Hi robe,

libxml2-2.dll was the problem.

From the C:\Program Files\PostgreSQL\9.1\bin directory, I opened a command window and ran "copy /Y libxml2.dll libxml2-2.dll" and ran the postgis-pg91x64-setup-2.0.1-1.exe installation.

For the record, both my postgres and postgis installations were done from standalone installations from "get.enterprisedb.com".

So there looks like this defect has resurfaced.

[mstucka]

I'm getting what I believe may be a problem related to #1824 (closed, but reportedly recurring after it was closed), though my error message shows up slightly differently, with a variable: ERROR: could not load library "C:/Program Files/Postgres/lib/postgis-2.0.dll": %1 is not a valid Win32 application.

Windows 7 64-bit, Postgres 9.2.4-1 64-bit downloaded directly, PostGIS 2.0.3-2 downloaded directly.

I tried putting copies of libxml2 and libxml2-2 from /lib in /bin/postgisgui without success.

[robe]

mstucka,

postgisgui standalon is just for the gui, has nothing to do with this error.

It's the libxml2-2.dll in the bin folder you want to replace with the libxml2.dll in bin folder.

Give that a try and see if it works.

This error notice also happens if you installed the WRONG version of PostGIS 2.0.3-2. Note there are 2 of these and if you are running Postgres 9.2 x64 you want this installer: ​http://download.osgeo.org/postgis/windows/pg92/postgis-pg92x64-setup-2.0.3-2.exe or the binaries (​http://download.osgeo.org/postgis/windows/pg92/postgis-pg92-binaries-2.0.3w64-2.zip). (the non-labeled installer one is for 32-bit ). I'll be changing next go around to be clearer (it was just that 32-bit was the only for a while and I didn't tack on the 32-bit when 64-bit came along though I do on the zip)

[mstucka]

Robe, you're a scholar and a gentleman(-lady?). Indeed I had a 32-bit vs. 64-bit mismatch I'd somehow overlooked. I apologize. I'm marking this back as fixed, on the premise the problems of 7 months ago haven't recurred.

Please accept my gratitude and apologies.

[robe]

np and sorry for the confusing labeling. I'll fix in 2.1 to be clearer.

Regina