Ticket #1824 (closed defect: fixed)

Opened 12 months ago

Last modified 6 months ago

Installation on windows 64 failed

Reported by: pierrevandelaar Owned by: robe
Priority: medium Milestone: PostGIS 2.0.1
Component: build/upgrade/install Version: 2.0.x
Keywords: Cc:

Description

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

Change History

Changed 12 months ago by robe

  • owner changed from pramsey to robe
  • component changed from postgis to build/upgrade/install

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

Changed 12 months ago by 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.

Changed 12 months ago by 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.

Changed 12 months ago by 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?

Changed 12 months ago by 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.

Changed 12 months ago by 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.

Changed 12 months ago by pierrevandelaar

  • status changed from new to closed
  • resolution set to fixed

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....

Changed 12 months ago by 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.

Changed 6 months ago by 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?

Changed 6 months ago by 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.

Changed 6 months ago by 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.

Note: See TracTickets for help on using tickets.