<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>The error message at the beggining is:</div><div><br></div><div>user@ubuntu:/usr/local/pgsql/share/contrib/postgis-2.0$ psql -d test -f postgis.sql<br>SET<br>BEGIN<br>psql:postgis.sql:69: ERROR: could not access file "$libdir/postgis-2.0": No such file or directory<br>psql:postgis.sql:74: ERROR: current transaction is aborted, commands ignored until end of transaction block</div><div>psql:postgis.sql:81: ERROR: current transaction is aborted, commands ignored until end of transaction block<br><br></div><div><br></div><div>etc.</div><div><br></div><div>I don't know what's wrong with that and i'm stuck here. I would appreciate any help!</div><div><br></div><div>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.<br></div><div><br><span></span></div><div><br><span></span></div><div><span></span></div><div><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Nicolas Ribot <nicolas.ribot@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> Giannis Giakoumidakis <ggiakoumidakis@yahoo.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, April 20, 2012 2:26 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] Question about the right installation of postgis 2.0.0<br> </font> </div> <br>
On 20 April 2012 11:16, Giannis Giakoumidakis <<a ymailto="mailto:ggiakoumidakis@yahoo.com" href="mailto:ggiakoumidakis@yahoo.com">ggiakoumidakis@yahoo.com</a>> wrote:<br>> My pgAdminIII still uses postgresql 8.4, even though i've installed 9.1.<br>> Anyway, I follow instructions from "2.5. Create a spatially-enabled database<br>> on PostgreSQL lower than 9.1".<br>><br>> When I get to the:<br>> "Now load the PostGIS object and function definitions into your database by<br>> loading the postgis.sql definitions file (located in [prefix]/share/contrib<br>> as specified during the configuration step).<br>> psql -d [yourdatabase] -f postgis.sql."<br>><br>> I get many errors ending like:<br>><br>> "psql:postgis.sql:6075: ERROR: current transaction is aborted, commands<br>> ignored until end of transaction block<br>> psql:postgis.sql:6081: ERROR: current transaction is aborted, commands<br>>
ignored until end of transaction block<br>> ROLLBACK".<br>><br>> Anyone has an idea about that?<br>><br><br>Hi,<br><br>Look at he first error message, that is relevant. All other messages<br>are the same (transaction abort).<br><br>When you say "still using 8.4", you mean you have 2 running instances<br>(8 and 9) ?<br><br>Nicolas<br><br><br> </div> </div> </div></body></html>