[postgis-users] PostGIS Installation Issues

[yoda2nd]

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 <yoda2nd at niacc.org> 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
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users