[postgis-users] Installing PostGIS - createlang plpgsql / lwpostgis.sql / spatial_ref_sys.sql?

[Adam]

Below you can see I'm getting this error:

[postgres at localhost postgis-1.1.0]$ psql  -s -d geo -f lwpostgis.sql
***(Single step mode: verify
command)*******************************************
BEGIN;
***(press return to proceed or enter x and return to
cancel)********************

BEGIN
***(Single step mode: verify
command)*******************************************
CREATE OR REPLACE FUNCTION histogram2d_in(cstring)
        RETURNS histogram2d
        AS '$libdir/liblwgeom.so.1.1', 'lwhistogram2d_in'
        LANGUAGE 'C' IMMUTABLE STRICT;
***(press return to proceed or enter x and return to
cancel)********************

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


I looked up this error and I found that you need to run "ldconfig" to solve
this.  I read that this is a common problem on Linux.  Would it be possible
to get the FAQ to include this isse?




----- Original Message ----- 
From: <jcradock at me3.com>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Cc: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Monday, December 26, 2005 2:10 PM
Subject: Re: [postgis-users] Installing PostGIS - createlang plpgsql /
lwpostgis.sql / spatial_ref_sys.sql?


> Yes. You need to enabled and load PostGIS for each database you would like
> GIS extensions enabled.
>
> > I'm at the part in installing PostGIS where I'm doing:
> >
> >
> >
> > 1.  PostGIS requires the PL/pgSQL procedural language extension. Before
> > loading the lwpostgis.sql file, you must first enable PL/pgSQL. You
should
> > use the createlang command. The PostgreSQL Programmer's Guide has the
> > details if you want to this manually for some reason.
> >
> > # createlang plpgsql [yourdatabase]
> >
> > 2.  Now load the PostGIS object and function definitions into your
> > database
> > by loading the lwpostgis.sql definitions file.
> >
> > # psql -d [yourdatabase] -f lwpostgis.sql
> >
> > 3.  The PostGIS server extensions are now loaded and ready to use.
> > For a complete set of EPSG coordinate system definition identifiers, you
> > can
> > also load the spatial_ref_sys.sql definitions file and populate the
> > SPATIAL_REF_SYS table.
> >
> > # psql -d [yourdatabase] -f spatial_ref_sys.sql
> >
> >
> >
> > My question is:  Are you loading the PostGIS extensions on a Database by
> > Database level?  If I start a new database will it just be a plain
> > PostgreSQL DB until you do the above commands, and at that point when
the
> > commands finish will the DB now be PostGIS enabled?
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
>
>
>
> -----
> James Cradock, jcradock at me3.com
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users