[postgis-users] PostGIS Installation Issues

[yoda2nd]

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 <yoda2nd at niacc.org> 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 <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
> >
> >
> > _______________________________________________
> > 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