Could be a password issue, though that usually gets written to the log files. Does your password have any ' or " in it. I think we might still have issue with that. It sounds like it might have got passed copying over the files, so you can probably just enable PostGIS anyway in the database of your choosing and see if that works. Just connect to the database you want to spatially enable and try: CREATE EXTENSION postgis; If it does, you are probably fine. We eventaully plan to get rid of the template_postgis database as it's been nothing but frustration for us. e.g. the postgis_topology doesn't change the database path when used from a template and if we didn't have it, we wouldn't even need to have to ask for postgres credentials, thus dismissing a long standing issue we've been dragging our feet to fix and a part that's taking up a good chunk of our setup script :) Thanks, Regina
_____ From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Nathan Swain Sent: Tuesday, October 09, 2012 3:57 PM To: postgis-users@postgis.refractions.net Subject: [postgis-users] Installing 64-bit PostGIS 2.0.1 with WindowsInstaller I'm trying to install the 64-bit PostGIS 2.0.1 using the windows installer (http://postgis.refractions.net/download/windows/#postgis-installers).The operating system I am installing it on is Windows Server 2008 R2 Enterprise 64-bit. I have already installed the following version of PostgreSQL: PostgreSQL 9.2.1, compiled by Visual C++ build 1600, 64-bit. When I install PostGIS, it throws the following error: Database creation failed. It asks if I would like to view the error log. When I reply with "Yes," it does not write the file and the installation does not complete. So I don't know what the exact error is. I have also tried installing it using the stack builder with the same result. Any help would be welcome. Here is the details report from the installer: Output folder: C:\Users\NATHAN~1\AppData\Local\Temp\postgis_installer Installer running on 64-bit host UserName=postgres Password=********* Port=**** Checking for existing PostGIS installation... Output folder: C:\Program Files\PostgreSQL\9.2\bin Extract: libcharset-1.dll... 100% Extract: libgcc_s_sjlj-1.dll... 100% Extract: libgdal-1.dll... 100% Extract: libgeos-3-3-5.dll... 100% Extract: libgeos_c-1.dll... 100% Extract: libiconv-2.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.2\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: libcharset-1.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.2\bin\postgisgui\etc\fonts Extract: fonts.conf... 100% Extract: fonts.dtd... 100% Output folder: C:\Program Files\PostgreSQL\9.2\bin\postgisgui\etc\gtk-2.0 Extract: gtkrc... 100% Extract: im-multipress.conf... 100% Output folder: C:\Program Files\PostgreSQL\9.2\bin\postgisgui\etc\pango Extract: pango.modules... 100% Output folder: C:\Program Files\PostgreSQL\9.2\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.2\bin\postgisgui\lib\gdk-pixbuf-2.0\2.10.0 Extract: loaders.cache... 100% Output folder: C:\Program Files\PostgreSQL\9.2\bin\postgisgui\lib\glib-2.0\include Extract: glibconfig.h... 100% Output folder: C:\Program Files\PostgreSQL\9.2\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.2\bin\postgisgui\lib\gtk-2.0\include Extract: gdkconfig.h... 100% Output folder: C:\Program Files\PostgreSQL\9.2\bin\postgisgui\lib\gtk-2.0\modules Extract: libgail.dll... 100% Output folder: C:\Program Files\PostgreSQL\9.2\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.2\bin\postgisgui\share\themes\Default\gtk-2.0-key Extract: gtkrc... 100% Output folder: C:\Program Files\PostgreSQL\9.2\bin\postgisgui\share\themes\Default\gtk-2.0-key-old Extract: gtkrc Output folder: C:\Program Files\PostgreSQL\9.2\bin\postgisgui\share\themes\Emacs\gtk-2.0-key Extract: gtkrc... 100% Output folder: C:\Program Files\PostgreSQL\9.2\bin\postgisgui\share\themes\MS-Windows\gtk-2.0 Extract: gtkrc... 100% Output folder: C:\Program Files\PostgreSQL\9.2\bin\postgisgui\share\themes\Raleigh\gtk-2.0 Extract: gtkrc... 100% Output folder: C:\Program Files\PostgreSQL\9.2\doc\contrib Extract: postgis-2.0.pdf... 100% Output folder: C:\Program Files\PostgreSQL\9.2\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.2\lib Extract: postgis-2.0.dll... 100% Extract: rtpostgis-2.0.dll... 100% Output folder: C:\Program Files\PostgreSQL\9.2\pgAdmin III\plugins.d Extract: postgis.shp2pgsql-gui.ini... 100% Output folder: C:\Program Files\PostgreSQL\9.2\share\contrib\postgis-2.0 Extract: legacy.sql... 100% Extract: legacy_minimal.sql... 100% Extract: postgis.sql... 100% Extract: postgis_comments.sql... 100% Extract: postgis_drop_after.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: tiger_geocoder_comments.sql... 100% Extract: topology.sql... 100% Extract: topology_comments.sql... 100% Extract: topology_upgrade_20_minor.sql... 100% Extract: uninstall_legacy.sql... 100% Extract: uninstall_postgis.sql... 100% Extract: uninstall_rtpostgis.sql... 100% Output folder: C:\Program Files\PostgreSQL\9.2\share\contrib\postgis-2.0\extras\history_table Extract: history_table.sql... 100% Extract: README... 100% Output folder: C:\Program Files\PostgreSQL\9.2\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.2\share\contrib\postgis-2.0\extras\rpm Extract: README... 100% Output folder: C:\Program Files\PostgreSQL\9.2\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.2\share\contrib\postgis-2.0\extras\rpm\spec Extract: postgis.spec... 100% Output folder: C:\Program Files\PostgreSQL\9.2\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.2\share\contrib\postgis-2.0\extras\tiger_geocoder Extract: README... 100% Output folder: C:\Program Files\PostgreSQL\9.2\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2 011 Extract: census_loader.sql... 100% Extract: create_geocode.bat... 100% Extract: create_geocode.sh... 100% Extract: create_geocode.sql... 100% Extract: geocode_settings.sql... 100% Extract: README... 100% Extract: tiger_loader_2011.sql... 100% Extract: upgrade_geocode.sql... 100% Extract: upgrade_geocoder.bat... 100% Extract: upgrade_geocoder.sh... 100% Output folder: C:\Program Files\PostgreSQL\9.2\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2 011\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.2\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2 011\legacy_import\tiger2008 Extract: import_tiger_shps.sh... 100% Output folder: C:\Program Files\PostgreSQL\9.2\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2 011\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.2\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2 011\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.2\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2 011\tables Extract: lookup_tables_2011.sql... 100% Output folder: C:\Program Files\PostgreSQL\9.2\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2 011\topology Extract: README... 100% Extract: tiger_topology_loader.sql... 100% Output folder: C:\Program Files\PostgreSQL\9.2\share\contrib\postgis-2.0\extras\tiger_geocoder\tiger_2 011\utility Extract: cull_null.sql... 100% Extract: levenshtein_ignore_case.sql... 100% Extract: nullable_levenshtein.sql... 100% Extract: set_search_path.sql... 100% Extract: utmzone.sql... 100% Output folder: C:\Program Files\PostgreSQL\9.2\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.2\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.2\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.2\share\extension Extract: postgis--2.0.0--2.0.1.sql... 100% Extract: postgis--2.0.0alpha1--2.0.1.sql... 100% Extract: postgis--2.0.0alpha2--2.0.1.sql... 100% Extract: postgis--2.0.0alpha3--2.0.1.sql... 100% Extract: postgis--2.0.0alpha4--2.0.1.sql... 100% Extract: postgis--2.0.0alpha5--2.0.1.sql... 100% Extract: postgis--2.0.0alpha6--2.0.1.sql... 100% Extract: postgis--2.0.0beta1--2.0.1.sql... 100% Extract: postgis--2.0.0beta2--2.0.1.sql... 100% Extract: postgis--2.0.0beta3--2.0.1.sql... 100% Extract: postgis--2.0.0beta4--2.0.1.sql... 100% Extract: postgis--2.0.0rc1--2.0.1.sql... 100% Extract: postgis--2.0.0rc2--2.0.1.sql... 100% Extract: postgis--2.0.1.sql... 100% Extract: postgis--unpackaged--2.0.1.sql... 100% Extract: postgis.control... 100% Extract: postgis.sql... 100% Extract: postgis_topology--2.0.0--2.0.1.sql... 100% Extract: postgis_topology--2.0.0alpha1--2.0.1.sql... 100% Extract: postgis_topology--2.0.0alpha2--2.0.1.sql... 100% Extract: postgis_topology--2.0.0alpha3--2.0.1.sql... 100% Extract: postgis_topology--2.0.0alpha4--2.0.1.sql... 100% Extract: postgis_topology--2.0.0alpha5--2.0.1.sql... 100% Extract: postgis_topology--2.0.0alpha6--2.0.1.sql... 100% Extract: postgis_topology--2.0.0beta1--2.0.1.sql... 100% Extract: postgis_topology--2.0.0beta2--2.0.1.sql... 100% Extract: postgis_topology--2.0.0beta3--2.0.1.sql... 100% Extract: postgis_topology--2.0.0beta4--2.0.1.sql... 100% Extract: postgis_topology--2.0.0rc1--2.0.1.sql... 100% Extract: postgis_topology--2.0.0rc2--2.0.1.sql... 100% Extract: postgis_topology--2.0.1.sql... 100% Extract: postgis_topology--unpackaged--2.0.1.sql... 100% Extract: postgis_topology.control... 100% Extract: postgis_topology.sql... 100% Output folder: C:\Program Files\PostgreSQL\9.2\utils Extract: create_undef.pl... 100% Extract: postgis_proc_upgrade.pl... 100% Extract: postgis_restore.pl... 100% Extract: profile_intersects.pl... 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% Creating template database... Database creation failed. Database creation failed.
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
