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