[postgis-users] Help with install

Wood Brent pcreso at pcreso.com
Mon Mar 29 18:25:45 PST 2004

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:

 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

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


  Brent Wood

More information about the postgis-users mailing list