<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>PostGIS 1.4 and PostgreSQL 8.4</TITLE>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18812"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial>Dave,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial>Both should work fine. The version we compiled was the
newest libiconv2, but we tested the shp2pgsql with the old version and the new
and it seemed to work fine for us in either case and didn't notice any issues
with the PostgreSQL behavior we have.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial>So I think you are fine sticking with what is packaged with
the PostgreSQL 8.4 if its got the same name.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial>The installation issues discussed before were caused because
PostGIS install tried to overwrite the libiconv-2.dll which was already present
in PostgreSQL installs so the solution has always been to just skip it if you
have it. Although in my PostgreSQL 8.4 install for some reason the file
that I got when installing was libiconv.dll (which is the same as libiconv-2.dll
more or less), but PostGIS the way it is compiled needs it to be called
libiconv-2.dll</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial>Mark correct me if anything I send is
wrong.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=980503306-06082009><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-devel-bounces@postgis.refractions.net
[mailto:postgis-devel-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Waddell, Dave FOR:EX<BR><B>Sent:</B> Wednesday, August 05, 2009 6:57
PM<BR><B>To:</B> postgis-devel@postgis.refractions.net<BR><B>Subject:</B>
[postgis-devel] PostGIS 1.4 and PostgreSQL 8.4<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format --><BR>
<P><FONT size=2 face=Arial>I'm getting ready to build a custom install of
PostgreSQL 8.4 and PostGIS 1.4 for a locked down gov't 32bit vista
installation.</FONT></P>
<P><FONT size=2 face=Arial>(Normal installs will not work due to access
restrictions).</FONT> </P>
<P><FONT size=2 face=Arial>PostgreSQL binaries
(postgresql-8.4.0-1-windows-binaries.zip) were downloaded from </FONT><A
href="http://www.enterprisedb.com/products/pgbindownload.do"><U><FONT
color=#0000ff size=2
face=Arial>http://www.enterprisedb.com/products/pgbindownload.do</FONT></U></A></P>
<P><FONT size=2 face=Arial>PostGIS binaries (postgis-pg84-binaries-1.4.0.zip)
were downloaded from </FONT><A
href="http://postgis.refractions.net/download/windows/"><U><FONT color=#0000ff
size=2
face=Arial>http://postgis.refractions.net/download/windows/</FONT></U></A></P>
<P><FONT size=2 face=Arial>In looking at the /bin for the PostgreSQL 8.4 install
and comparing to the PostGIS 1.4 binaries,</FONT> <BR><FONT size=2
face=Arial>both /bin directories contain libiconv-2.dll , but they are a
different size.</FONT> </P>
<P><FONT size=2 face=Arial>PostgreSQL
PostGIS</FONT> <BR><FONT size=2
face=Arial>947KB
905KB</FONT> </P>
<P><FONT size=2 face=Arial>There have been installation issues posted before
about libiconv.dll.</FONT> </P>
<P><FONT size=2 face=Arial>Which is the correct dll to use??</FONT> </P>
<P><FONT size=2 face=Arial>Thanks in advance</FONT> </P><BR><BR><BR>
<P><SPAN lang=en-us><FONT size=2 face="Comic Sans MS">Dave Waddell</FONT></SPAN>
<BR><SPAN lang=en-us><FONT size=2 face="Comic Sans MS">Forest Analysis &
Inventory Branch</FONT></SPAN> <BR><SPAN lang=en-us><FONT size=2
face="Comic Sans MS">Ministry of Forests & Range</FONT></SPAN>
</P><BR></BODY></HTML>