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

[Giannis Giakoumidakis]

The error message at the beggining is:

user at ubuntu:/usr/local/pgsql/share/contrib/postgis-2.0$ psql -d test -f postgis.sql
SET
BEGIN
psql:postgis.sql:69: ERROR:  could not access file "$libdir/postgis-2.0": No such file or directory
psql:postgis.sql:74: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:postgis.sql:81: ERROR:  current transaction is aborted, commands ignored until end of transaction block



etc.

I don't know what's wrong with that and i'm stuck here. I would appreciate any help!

I use Osgeo Live 5.5 that comes with postgresql 8.4 and i have installed also the 9.1 one.The databases in pgAdminIII uses 8.4.






________________________________
 From: Nicolas Ribot <nicolas.ribot at gmail.com>
To: Giannis Giakoumidakis <ggiakoumidakis at yahoo.com> 
Sent: Friday, April 20, 2012 2:26 PM
Subject: Re: [postgis-users] Question about the right installation of postgis 2.0.0
 
On 20 April 2012 11:16, Giannis Giakoumidakis <ggiakoumidakis at yahoo.com> wrote:
> 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?
>

Hi,

Look at he first error message, that is relevant. All other messages
are the same (transaction abort).

When you say "still using 8.4", you mean you have 2 running instances
(8 and 9) ?

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