[postgis-users] Help with install

strk strk at keybit.net
Mon Mar 29 22:56:27 PST 2004


On Mon, Mar 29, 2004 at 06:25:45PM -0800, Wood Brent wrote:
> I'm trying to install postgis.
> 
> Postgres, GEOS & Proj are all installed OK.
> the command "createlang plpgsql test" works fine & the language is
> installed in the db.
> 
> when I run "psql -d test -f postgis.sql", however I get errors.
> 
> The first few lines of output are:
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> 
> BEGIN
>         message
> ------------------------
>  PL/PgSQL is installed.
> (1 row)
> 
> psql:postgis.sql:44: NOTICE:  type "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> psql:postgis.sql:44: ERROR:  could not access file 
> "$libdir/libpostgis.so.0.8": No such file or directory
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> 
> The file libpostgis.so.0.8 is located in
> /usr/local/pgsql/lib/libpostgis.so.0.8
> 
> 
> What do I need to do to have the library picked up by postgres so I can 
> install postgis in the database using the supplied sql file?
> 
> I assume the $libdir environment variable needs to be set, but I can't 
> find a reference in the install docs. I have got it to install by using sed to
> replace $libdir with the hard coded path, but figure this is not the ideal
> approach.

$libdir should point by default to: /usr/local/pgsql/lib/postgresql/
--strk;

> 
> 
> Thanks,
> 
>   Brent Wood
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list