<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
code
{mso-style-priority:99;
font-family:"Courier New";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Try running the sql from within the psql command prompt. It will give more information. You can also build the 9.1 version of pgAdminIII from source though that will probably require you building wxWidgets as well. I have done this multiple times in the last few days and can attest to it working well.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>--Jack<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of </b>Giannis Giakoumidakis<br><b>Sent:</b> Friday, April 20, 2012 5:17 AM<br><b>To:</b> Nicolas Ribot; PostGIS Users Discussion<br><b>Subject:</b> Re: [postgis-users] Question about the right installation of postgis 2.0.0<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal style='background:white'><span style='color:black'>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".<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><p class=MsoNormal style='background:white'><span style='color:black'>When I get to the:<o:p></o:p></span></p><div><p class=MsoNormal style='background:white'><span style='color:black'>"Now load the PostGIS object and function definitions into your database by loading the </span><code><span style='font-size:10.0pt;color:black'>postgis.sql</span></code><span style='color:black'> definitions file (located in </span><code><span style='font-size:10.0pt;color:black'>[prefix]/share/contrib</span></code><span style='color:black'> as specified during the configuration step). <o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><strong><span style='color:black'>psql -d [yourdatabase] -f postgis.sql."</span></strong><span style='color:black'><o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'>I get many errors ending like:<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'>"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".<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'>Anyone has an idea about that?<o:p></o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><div><p class=MsoNormal style='background:white'><span style='color:black'><o:p> </o:p></span></p></div><div><div><div><div class=MsoNormal align=center style='text-align:center;background:white'><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'><hr size=1 width="100%" align=center></span></div><p class=MsoNormal style='background:white'><b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'>From:</span></b><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'> Nicolas Ribot <<a href="mailto:nicolas.ribot@gmail.com">nicolas.ribot@gmail.com</a>><br><b>To:</b> Giannis Giakoumidakis <<a href="mailto:ggiakoumidakis@yahoo.com">ggiakoumidakis@yahoo.com</a>>; PostGIS Users Discussion <<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>> <br><b>Sent:</b> Wednesday, April 18, 2012 7:42 PM<br><b>Subject:</b> Re: [postgis-users] Question about the right installation of postgis 2.0.0</span><span style='color:black'><o:p></o:p></span></p></div><p class=MsoNormal style='margin-bottom:12.0pt;background:white'><span style='color:black'><br>On 18 April 2012 18:12, Giannis Giakoumidakis <<a 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><a href="http://postgis.org/documentation/manual-2.0/postgis_installation.html#create_new_db">http://postgis.org/documentation/manual-2.0/postgis_installation.html#create_new_db</a><br><br>Nicolas<br><br>><br>><br>> ________________________________<br>> From: Sandro Santilli <<a href="mailto:strk@keybit.net">strk@keybit.net</a>><br>> To: Giannis Giakoumidakis <<a href="mailto:ggiakoumidakis@yahoo.com">ggiakoumidakis@yahoo.com</a>>; PostGIS Users<br>> Discussion <<a 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 | <a href="http://strk.keybit.net">http://strk.keybit.net</a> - <a href="http://vizzuality.com">http://vizzuality.com</a><br>> `-o------'<br>><br>><br>><br>><br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>><br><br><o:p></o:p></span></p></div></div></div></div></body></html>