Hello, Thanks very much for the help. ldconfig fixed the problem right away, even attempted a second fresh install and was able to get everything working the first time through.
Thanks very much for the help. On Tue, 2010-05-04 at 13:37 -0700, Mike Toews wrote: > For reasons beyond me, I know that after installing recent builds of > PostGIS on Ubuntu, you are required to also run: > > sudo ldconfig > > I've contemplated making a trac ticket for it, but I'm not exactly > sure what the problem is or if it can be directly addressed in the > "make install" target (or if it was, is it now broken). See if that > command works for you. > > -Mike > > On 4 May 2010 13:30, yoda2nd <[email protected]> wrote: > > 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 > > > _______________________________________________ > 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
