<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16535"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial>Arnauld,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial>If you installed PostGIS via stack builder, the easiest way to
create a PostGIS database is to </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial>create a database and use template_postgis as the
template.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=979291101-17052010></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=979291101-17052010>We have an article that details some of
this</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=979291101-17052010><A
href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01">http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01</A></SPAN></FONT></FONT></FONT></DIV></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial>If you are trying to spatially enable an already existing
database, then make sure you have plpgsql language enabled in the database
before you install the postgis scripts. You can do this with a
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial>CREATE LANGUAGE plpgsql;</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial>I think PostgreSQL 8.4+ has it installed by default at least
for windows, but 8.3 may not.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=979291101-17052010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=979291101-17052010></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2><SPAN
class=979291101-17052010>We</SPAN> take it from your below that you are trying to install PostGIS 1.3 instead of the newer PostGIS 1.5. </FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=979291101-17052010>For
</SPAN>PostGIS 1.5 and 1.4, the file you need to install is postgis.sql (prior versions was lwpostgis.sql).</FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT
size=2></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2>I<SPAN
class=979291101-17052010>f there isn't any particular reason why you are using
an older version, I would suggest to use PostGIS 1.5. It has a lot more
functionality than 1.3.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=979291101-17052010></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=979291101-17052010></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=979291101-17052010>Leo and Regina</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=979291101-17052010><A
href="http://www.postgis.us">http://www.postgis.us</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=979291101-17052010></SPAN></FONT></FONT></FONT> </DIV>
<DIV><BR></DIV>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>arnauld ndefo<BR><B>Sent:</B> Sunday, May 16, 2010 7:26 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
installation on windows<BR></FONT><BR></DIV>
<DIV></DIV>
<TABLE border=0 cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD vAlign=top>
<DIV id=yiv1894484862>Hi everybody,<BR>i am a new developer who use a
mapnik to build my own map. I use Window instead of ubuntu.I want to know
how to install postgis on windows?<BR>when i do "psql -d gis -f
"c:\Program Files\PostgreSQL\8.3\share\co<BR>ntrib\lwpostgis.sql" on my
windows command shell i have this list of error:
<BR><BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4858: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4864: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4870: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4876: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4882: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4888: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4894: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4900: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4906: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4912: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4918: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4923: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4928: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4933: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4938: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4948: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4958: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4968: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4979: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4989: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:4999: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5009: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5019: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5025: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5031: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5041: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5051: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5061: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5071: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5077: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR>psql:c:/Program
Files/PostgreSQL/8.3/share/contrib/lwpostgis.sql:5083: ERROR:
c<BR>urrent transaction is aborted, commands ignored until end of
transaction block<BR><BR>I don't know how to result this problem, please
help me<BR><BR>thank you<BR><BR><BR><BR><BR>Ndefo Kamgne Arnauld<BR>Cité
Ettayour,Immeuble Bolbol 1,Appartement
A2,Ariana<BR>0021624249357</DIV></TD></TR></TBODY></TABLE><BR></BODY></HTML>