[postgis-users] PostGIS Installation Issues

[Mike Toews]

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
>