<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>My pgAdminIII still uses postgresql 8.4, even though i've installed 9.1. Anyway, I follow instructions from "2.5. Create a spatially-enabled database on PostgreSQL lower than 9.1".</div><div><br></div><span>When I get to the:</span><br><div>
"Now load the PostGIS object and function definitions into your database by
loading the <code class="filename">postgis.sql</code> definitions file (located in
<code class="filename">[prefix]/share/contrib</code> as specified during the
configuration step).
</div><div>
<span><strong class="command">psql -d [yourdatabase] -f postgis.sql."</strong></span></div><div><span><strong class="command"><br></strong></span></div><div>I get many errors ending like:</div><div><br></div><div> "psql:postgis.sql:6075: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>psql:postgis.sql:6081: ERROR: current transaction is aborted, commands ignored until end of transaction block<br>ROLLBACK".</div><div><br></div><div>Anyone has an idea about that?<br><span><strong class="command"></strong></span></div><div><span><strong class="command"><br></strong></span>
</div><div><span></span></div><div><br><span></span></div><div><span></span></div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Nicolas Ribot <nicolas.ribot@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> Giannis Giakoumidakis <ggiakoumidakis@yahoo.com>; PostGIS Users Discussion <postgis-users@postgis.refractions.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Wednesday, April 18, 2012 7:42 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] Question about the right installation of postgis 2.0.0<br> </font> </div> <br>
On 18 April 2012 18:12, Giannis Giakoumidakis <<a ymailto="mailto:ggiakoumidakis@yahoo.com" href="mailto:ggiakoumidakis@yahoo.com">ggiakoumidakis@yahoo.com</a>> wrote:<br>> So if I installed it correct, my next question is how I enable Postgis2.0.0<br>> in PgAdminIII (i have the 1.12.2-1 version). I created a new database with<br>> "template_postgis" but when I ask "select postgis_full_version()" I get<br>> "POSTGIS=1.5.3" so the new Postgis has not been enabled. Can anyone explain<br>> me how i do this or send me a tutorial/documentation? Thanx for the help.<br>><br><br>Hi,<br><br>You have to install Postgis 2.0 on the database you are working on.<br>The template_postgis you see in PgAdmin was probably created during a<br>postgis 1.5 installation.<br><br>You will find instructions here:<br>http://postgis.org/documentation/manual-2.0/postgis_installation.html#create_new_db<br><br>Nicolas<br><br>><br>><br>>
________________________________<br>> From: Sandro Santilli <<a ymailto="mailto:strk@keybit.net" href="mailto:strk@keybit.net">strk@keybit.net</a>><br>> To: Giannis Giakoumidakis <<a ymailto="mailto:ggiakoumidakis@yahoo.com" href="mailto:ggiakoumidakis@yahoo.com">ggiakoumidakis@yahoo.com</a>>; PostGIS Users<br>> Discussion <<a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>><br>> Sent: Tuesday, April 17, 2012 5:00 PM<br>> Subject: Re: [postgis-users] Question about the right installation of<br>> postgis 2.0.0<br>><br>> On Tue, Apr 17, 2012 at 06:50:14AM -0700, Giannis Giakoumidakis wrote:<br>>> I have followed the instructions from the manual. I have done the<br>>> "configure" and "make" steps successfully and i got the message "PostGIS was<br>>> built successfully. Ready to install.". But when
I make "sudo make install"<br>>> I don't get a message of full or succesfull installation, nor a message of<br>>> mistake. It ends with that:<br>>><br>>><br>>> make[2]: Leaving directory<br>>> `/home/user/Desktop/diploma/Tools/Linux/postgis-2.0.0/extensions/postgis_topology'<br>>> make[1]: Leaving directory<br>>> `/home/user/Desktop/diploma/Tools/Linux/postgis-2.0.0/extensions'<br>>><br>>><br>>> So I wanted to be sure that I've done the installation right and i won't<br>>> have problems after. Thanks for your advices.<br>><br>> You should be fine.<br>><br>> --strk;<br>><br>> ,------o-.<br>> | __/ | Delivering high quality PostGIS 2.0 !<br>> | / 2.0 | http://strk.keybit.net - http://vizzuality.com<br>> `-o------'<br>><br>><br>><br>><br>>
_______________________________________________<br>> postgis-users mailing list<br>> <a ymailto="mailto:postgis-users@postgis.refractions.net" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> http://postgis.refractions.net/mailman/listinfo/postgis-users<br>><br><br><br> </div> </div> </div></body></html>