The error message at the beggining is:
user@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.ri...@gmail.com>
To: Giannis Giakoumidakis <ggiakoumida...@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 <ggiakoumida...@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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
