[postgis-users] troubles installing PostGIS

[Mark Cave-Ayland]

Geoffrey Fairchild wrote:
> Output folder: C:\Users\*****\AppData\Local\Temp\postgis_installer
> UserName=postgres
> Password=**********
> Port=5432
> Checking for existing PostGIS installation...
> Output folder: C:\Program Files (x86)\PostgreSQL\8.3\bin
> Skipped: libiconv-2.dll
> Output folder: C:\Program Files (x86)\PostgreSQL\8.3\bin
> Extract: libgeos-3-0-3.dll... 100%
> Extract: libgeos_c-1.dll... 100%
> Extract: libproj.dll... 100%
> Extract: pgsql2shp.exe... 100%
> Extract: shp2pgsql.exe... 100%
> Output folder: C:\Program Files (x86)\PostgreSQL\8.3\doc\contrib
> Extract: README.pgsql2shp... 100%
> Extract: README.postgis... 100%
> Extract: README.shp2pgsql... 100%
> Output folder: C:\Program Files 
> (x86)\PostgreSQL\8.3\doc\contrib\html\postgis
> Extract: postgis.html... 100%
> Extract: style.css... 100%
> Output folder: C:\Program Files 
> (x86)\PostgreSQL\8.3\doc\contrib\html\postgis\jdbc
> Extract: allclasses-frame.html... 100%
> Extract: allclasses-noframe.html... 100%
> Extract: constant-values.html... 100%
> Extract: deprecated-list.html... 100%
> Extract: help-doc.html... 100%
> Extract: index-all.html... 100%
> Extract: index.html... 100%
> Extract: overview-frame.html... 100%
> Extract: overview-summary.html... 100%
> Extract: overview-tree.html... 100%
> Extract: package-list... 100%
> Extract: serialized-form.html... 100%
> Extract: stylesheet.css... 100%
> Output folder: C:\Program Files 
> (x86)\PostgreSQL\8.3\doc\contrib\html\postgis\jdbc\examples
> Extract: package-frame.html... 100%
> Extract: package-summary.html... 100%
> Extract: package-tree.html... 100%
> Extract: Test.html... 100%
> Extract: TestAutoregister.html... 100%
> Extract: TestBoxes.html... 100%
> Extract: TestJava2d.EventHandler.html... 100%
> Extract: TestJava2d.GisCanvas.html... 100%
> Extract: TestJava2d.html... 100%
> Extract: TestParser.html... 100%
> Extract: TestServer.html... 100%
> Extract: VersionPrinter.html... 100%
> Output folder: C:\Program Files 
> (x86)\PostgreSQL\8.3\doc\contrib\html\postgis\jdbc\org\postgis
> Extract: ComposedGeom.html... 100%
> Extract: DriverWrapper.html... 100%
> Extract: DriverWrapper.TypesAdder.html... 100%
> Extract: DriverWrapper.TypesAdder72.html... 100%
> Extract: DriverWrapper.TypesAdder74.html... 100%
> Extract: DriverWrapper.TypesAdder80.html... 100%
> Extract: DriverWrapperAutoprobe.html... 100%
> Extract: DriverWrapperLW.html... 100%
> Extract: Geometry.html... 100%
> Extract: GeometryCollection.html... 100%
> Extract: LinearRing.html... 100%
> Extract: LineString.html... 100%
> Extract: MultiLineString.html... 100%
> Extract: MultiPoint.html... 100%
> Extract: MultiPolygon.html... 100%
> Extract: package-frame.html... 100%
> Extract: package-summary.html... 100%
> Extract: package-tree.html... 100%
> Extract: PGbox2d.html... 100%
> Extract: PGbox3d.html... 100%
> Extract: PGboxbase.html... 100%
> Extract: PGgeometry.html... 100%
> Extract: PGgeometryLW.html... 100%
> Extract: Point.html... 100%
> Extract: PointComposedGeom.html... 100%
> Extract: Polygon.html... 100%
> Extract: Version.html... 100%
> Output folder: C:\Program Files 
> (x86)\PostgreSQL\8.3\doc\contrib\html\postgis\jdbc\org\postgis\binary
> Extract: BinaryParser.html... 100%
> Extract: BinaryWriter.html... 100%
> Extract: ByteGetter.BinaryByteGetter.html... 100%
> Extract: ByteGetter.html... 100%
> Extract: ByteGetter.StringByteGetter.html... 100%
> Extract: ByteSetter.BinaryByteSetter.html... 100%
> Extract: ByteSetter.html... 100%
> Extract: ByteSetter.StringByteSetter.html... 100%
> Extract: package-frame.html... 100%
> Extract: package-summary.html... 100%
> Extract: package-tree.html... 100%
> Extract: ValueGetter.html... 100%
> Extract: ValueGetter.NDR.html... 100%
> Extract: ValueGetter.XDR.html... 100%
> Extract: ValueSetter.html... 100%
> Extract: ValueSetter.NDR.html... 100%
> Extract: ValueSetter.XDR.html... 100%
> Output folder: C:\Program Files 
> (x86)\PostgreSQL\8.3\doc\contrib\html\postgis\jdbc\org\postgis\java2d
> Extract: Java2DWrapper.html... 100%
> Extract: package-frame.html... 100%
> Extract: package-summary.html... 100%
> Extract: package-tree.html... 100%
> Extract: PGShapeGeometry.html... 100%
> Extract: ShapeBinaryParser.html... 100%
> Output folder: C:\Program Files 
> (x86)\PostgreSQL\8.3\doc\contrib\html\postgis\jdbc\resources
> Extract: inherit.gif
> Output folder: C:\Program Files (x86)\PostgreSQL\8.3\jdbc
> Extract: postgis_1.3.5.jar... 100%
> Output folder: C:\Program Files (x86)\PostgreSQL\8.3\lib
> Extract: liblwgeom.dll... 100%
> Output folder: C:\Program Files (x86)\PostgreSQL\8.3\share\contrib
> Extract: lwpostgis.sql... 100%
> Extract: spatial_ref_sys.sql... 100%
> Output folder: C:\Program Files (x86)\PostgreSQL\8.3\share\contrib\postgis
> Extract: lwpostgis_upgrade.sql... 100%
> Output folder: C:\Program Files 
> (x86)\PostgreSQL\8.3\share\contrib\postgis\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 
> (x86)\PostgreSQL\8.3\share\contrib\postgis\topology
> Extract: README... 100%
> Extract: topology.sql... 100%
> Output folder: C:\Program Files 
> (x86)\PostgreSQL\8.3\share\contrib\postgis\utils
> Extract: create_undef.pl... 100%
> Extract: postgis_proc_upgrade.pl... 100%
> Extract: postgis_restore.pl... 100%
> Creating template database...
> Loading PLPGSQL language...
> Loading PostGIS functions...
> Create folder: C:\ProgramData\Microsoft\Windows\Start 
> Menu\Programs\PostGIS 1.3.5 for PostgreSQL 8.3
> Create shortcut: C:\ProgramData\Microsoft\Windows\Start 
> Menu\Programs\PostGIS 1.3.5 for PostgreSQL 8.3\PostGIS 1.3.5 
> Documentation.lnk
> Create shortcut: C:\ProgramData\Microsoft\Windows\Start 
> Menu\Programs\PostGIS 1.3.5 for PostgreSQL 8.3\PostGIS 1.3.5 JDBC Driver 
> Documentation.lnk
> Created uninstaller: C:\Program Files 
> (x86)\PostgreSQL\8.3\uninstall-postgis-pg83-1.3.5-1.exe
> DataBase=postgis
> Creating spatial database...
> Completed
> 
> Looks like everything besides the error worked just fine.  The log just 
> says "Skipped: libiconv-2.dll" in reference to the error.  In fact, I 
> just thought to open up the installer (thanks to 7-Zip), and I compared 
> the 2 libiconv-2.dll files - the one in the PostgreSQL bin folder and 
> the one in the PostGIS bin folder.  The PostgreSQL file is larger (946kb 
> vs 873kb) and has a more recent last modified time (1/6/09 vs 
> 12/16/08).  I'm guessing that I want the newer copy anyway, so perhaps 
> skipping over that file isn't such a bad thing.  Why does PostGIS 
> include that file in the first place if it's included with PostgreSQL?
> 
> Geoff


Hi Geoff,

This is interesting; I remember I had a conversation about the libiconv 
DLL a while back, since the PostgreSQL installer used to install a 
really old version as libiconv2.dll, whereas MingW builds iconv as 
libiconv-2.dll (with the extra hyphen). The consensus at the time was 
that we should leave PostgreSQL to use libiconv2.dll and distribute our 
own libiconv-2.dll as part of the installer, but I guess this part has 
changed - I'll CC to Dave for comment, as I don't know which versions of 
the PostgreSQL installer contain this change.

The reason that you see the error at the moment is, of course, because 
your current PostgreSQL instance already has the libiconv-2.dll file 
open for its own use.


ATB,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063