I tried your commands and got the same result. Below is the error message from postgis.sql. I have checked to make sure that postgis-1.5.so was there and it is. I have been unable to find libgeos_c.so with the same directory. However both Geos and Proj libraries compiled and installed without any known issues. PostGIS config picked them up correctly during ./configure.
psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:59: ERROR: could not load library "/usr/lib/postgresql/8.4/lib/postgis-1.5.so": libgeos_c.so.1: cannot open shared object file: No such file or directory Thanks for the help Mike. On Tue, 2010-05-04 at 12:47 -0700, Mike Toews wrote: > Here is an example from a shell (dash, the default for Ubuntu): > > # (optional) Create a new empty database "mydb" > sudo -u postgres createdb mydb > > # Add PL/pgSQL as a language > sudo -u postgres createlang plpgsql mydb > > # Spatially enable it (from the 1.5 and 8.4 stocks, edit this > depending on which combinaiton you have): > sudo -u postgres psql -f > /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql mydb > sudo -u postgres psql -f > /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql mydb > > If you want to see the error messages in more detail, then add " 2> > myerrout" to the end of the last two commands above, then view the > myerrorout file afterwards. > > -Mike > > On 4 May 2010 12:32, yoda2nd <[email protected]> wrote: > > Hello all, > > > > I have been trying to install PostGIS on Ubuntu Server for the last few > > days, however for some reason I can not get the SQL files (postgis.sql, > > spatial_ref_sys.sql, etc.) into the database. All I get is a screenfull > > of the following: > > > > psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7458: ERROR: > > current transaction is aborted, commands ignored until end of > > transaction block > > psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7465: ERROR: > > current transaction is aborted, commands ignored until end of > > transaction block > > psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7472: ERROR: > > current transaction is aborted, commands ignored until end of > > transaction block > > psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7478: ERROR: > > current transaction is aborted, commands ignored until end of > > transaction block > > psql:/gis/source_code/postgis-1.5.1/postgis/postgis.sql:7485: ERROR: > > current transaction is aborted, commands ignored until end of > > transaction block > > > > ./configure, make, make install all run fine without any errors that I > > can see. Any help would be much appreciated! > > > > Thanks > > yoda2nd > > > > > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
