[postgis-users] Question about the right installation of postgis 2.0.0

[Gold, Jack L (US SSA)]

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-bounces at postgis.refractions.net [mailto:postgis-users-bounces at 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.ribot at gmail.com<mailto:nicolas.ribot at gmail.com>>
To: Giannis Giakoumidakis <ggiakoumidakis at yahoo.com<mailto:ggiakoumidakis at yahoo.com>>; PostGIS Users Discussion <postgis-users at postgis.refractions.net<mailto:postgis-users at 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 <ggiakoumidakis at yahoo.com<mailto:ggiakoumidakis at 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 <strk at keybit.net<mailto:strk at keybit.net>>
> To: Giannis Giakoumidakis <ggiakoumidakis at yahoo.com<mailto:ggiakoumidakis at yahoo.com>>; PostGIS Users
> Discussion <postgis-users at postgis.refractions.net<mailto:postgis-users at 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 at postgis.refractions.net<mailto:postgis-users at postgis.refractions.net>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120420/c8f7db6c/attachment.html>