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

[Giannis Giakoumidakis]

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>
To: Giannis Giakoumidakis <ggiakoumidakis at yahoo.com>; PostGIS Users Discussion <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> 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>
> To: Giannis Giakoumidakis <ggiakoumidakis at yahoo.com>; PostGIS Users
> Discussion <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
> 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/7dfe9d9a/attachment.html>