<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18812"></meta>
<meta name="SKYPE_FRAMEID" content="HBROAMAKDT"></meta>
<meta id="skype_v3_tb_marker_id" name="SKYPE_PARSING_HAS_FINISHED" content="metacontent"></meta>
</head>
<body>
<div align="left">Hallo Ben</div>
<div align="left"> </div>
<div align="left">If I remember right you should have Application Stack Builder from that installation of postgresql. If so, you just mark postgis under spatial extensions for installation and then everything should be fixed.<br />
</div>
<div align="left">Hope that helps</div>
<div align="left">Nicklas</div>
<div align="left"> </div>
<div align="left"><br />
2009-09-12 benton101 wrote:<br />
<br />
<br />
>OS - Ubuntu 9.04 - (installed from a distro from a mag)<br />
>DB - PostgreSQL 8.4 - (installed from a binary package from the official<br />
>site)<br />
><br />
>Hi,<br />
>I am attempting to install PostGIS 1.4.0 using the install instructions<br />
>provided by the developers. As a new user to ubuntu I am not really<br />
>confident in what I am doing and these are the steps I have used so far;<br />
><br />
>GEOS -----------------------------------------------------------------<br />
>cd geos-3.1.1<br />
>./configure<br />
>make<br />
>sudo make install<br />
>cd ..<br />
><br />
>PROJ.4 ---------------------------------------------------------------<br />
>tar xzf proj-4.6.1.tar.gz<br />
>cd proj-4.6.1/nad<br />
>tar xzf ../../proj-datumgrid-1.4.tar.gz<br />
>cd ..<br />
>./configure<br />
>make<br />
>sudo make install<br />
>cd ..<br />
><br />
>PostGIS --------------------------------------------------------------<br />
>tar xzf postgis-1.4.0.tar.gz<br />
>cd postgis-1.4.0<br />
>./configure --with-pgconfig=/opt/PostgreSQL/8.4/bin/pg_config<br />
>--with-geosconfig=/usr/bin/geos-config<br />
>--with-projdir=/home/benton/proj-4.6.1<br />
>make<br />
>sudo make install<br />
>cd ..<br />
><br />
>Create a spatially-enabled database ----------------------------------<br />
>sudo su - postgres<br />
>createdb template_test<br />
>createlang plpgsql template_test<br />
><br />
>Everything at this point seems to be OK and then when I attempt to follow<br />
>these instructions<br />
>psql -d template_test -f<br />
>/opt/PostgreSQL/8.4/share/postgresql/contrib/postgis.sql<br />
><br />
>This is the last couple of lines for the command run above ...<br />
><br />
>psql:/opt/PostgreSQL/8.4/share/postgresql/contrib/postgis.sql:6927: ERROR: <br />
>current transaction is aborted, commands ignored until end of transaction<br />
>block<br />
>ROLLBACK<br />
><br />
>Would anyone know what could be the problem here?<br />
>Or better would there be some easier way of getting this installed on my<br />
>machine that the way I am doing it at the moment?<br />
>Thank You<br />
>Ben<br />
><br />
><br />
>-- <br />
>View this message in context: http://www.nabble.com/PostGIS-1.4-install-troubles-tp25412943p25412943.html<br />
>Sent from the PostGIS - User mailing list archive at Nabble.com.<br />
><br />
>_______________________________________________<br />
>postgis-users mailing list<br />
>postgis-users@postgis.refractions.net<br />
>http://postgis.refractions.net/mailman/listinfo/postgis-users<br />
><br />
></div>
</body>
</html>