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

[Adam]

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
>