[postgis-users] Failing: psql -d [yourdatabase] -f lwpostgis.sql

[Sasanka Gandavarapu]

I also got the same error as Adam while executing lwpostgis. But, it did not
affect my project. I am also curious to know where the bug is.

Sasanka

On 12/30/06, Adam <adam at spatialsystems.org> wrote:
>
> I did createlang, here is my error:
>
> [wohldad at localhost postgis-1.1.6]$
> /usr/local/src/database/postgresql-8.1.3/src/bin/psql/psql -d gpsrd_v2 -f
> lwpostgis.sql
> BEGIN
> psql:lwpostgis.sql:39: NOTICE:  type "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> psql:lwpostgis.sql:39: ERROR:  could not load library
> "/usr/local/pgsql/lib/liblwgeom.so.1.1": libgeos_c.so.1: cannot open
> shared
> object file: No such file or directory
> psql:lwpostgis.sql:44: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
> psql:lwpostgis.sql:52: ERROR:  current transaction is aborted, commands
> ignored until end of transaction block
>
>
> What I had to do to fix this is to add:
>
>   /usr/local/pgsql/lib
>   /usr/local/lib
>
> to "/etc/ld.so.conf" and run "ldconfig".
>
>
>
> ----- Original Message -----
> From: "Matthew Perry" <perrygeo at gmail.com>
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Sent: Friday, December 29, 2006 2:01 PM
> Subject: Re: [postgis-users] Failing: psql -d [yourdatabase] -f
> lwpostgis.sql
>
>
> > Adam,
> >
> > You may have to add the plpgsql language to your database first:
> >
> >  createlang -d [yourdatabase] plpgsql
> >
> > - matt
> >
> > On 12/29/06, Adam <adam at spatialsystems.org> wrote:
> >>
> >>
> >> I'm installing version 1.1.6 and everything is fine until the step:
> >>
> >> psql -d [yourdatabase] -f lwpostgis.sql
> >>
> >> It's all erroring out.  Any idea what the problem is or where I go to
> see
> >> what the error is?
> >>
> >> psql:lwpostgis.sql:3368: ERROR:  current transaction is aborted,
> commands
> >> ignored until end of transaction block
> >> psql:lwpostgis.sql:3375: ERROR:  current transaction is aborted,
> commands
> >> ignored until end of transaction block
> >> psql:lwpostgis.sql:3380: ERROR:  current transaction is aborted,
> commands
> >> ignored until end of transaction block
> >> psql:lwpostgis.sql:3385: ERROR:  current transaction is aborted,
> commands
> >> ignored until end of transaction block
> >> psql:lwpostgis.sql:3444: ERROR:  current transaction is aborted,
> commands
> >> ignored until end of transaction block
> >> psql:lwpostgis.sql:3462: ERROR:  current transaction is aborted,
> commands
> >> ignored until end of transaction block
> >> psql:lwpostgis.sql:3509: ERROR:  current transaction is aborted,
> commands
> >> ignored until end of transaction block
> >> ROLLBACK
> >> _______________________________________________
> >> postgis-users mailing list
> >> postgis-users at postgis.refractions.net
> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >>
> >>
> >>
> >
> >
> > --
> > Matthew T. Perry
> > GIS Analyst / Software Engineer
> > National Center for Ecological Analysis and Synthesis (NCEAS)
> > work: perry at nceas.ucsb.edu
> > web: http://www.perrygeo.net
> > _______________________________________________
> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061230/6763b518/attachment.html>