[postgis-users] error during postgis.sql command

[Michael Mallete]

as usual here i go again.

so i've installed my postgresql 7.4.3 from source. the
source tree is at /home/postgres/. i extracted my
postgis tarball at /home/postgres/contrib/. before i
ran ./configure for postgis, i installed proj 4 first
because i specified the makefile to make use of the
library. so installed proj 4 from source. so i
proceeded to postgis intallation. the installation
seemed succesful. then i created a database called
"postgisdb." then ran createlang plpgsql postgisdb.
first attempt, i tried to run psql -d  postgisdb -f
postgis.sql but the postgis.sql command wasn't
recognized (perhaps because i didn't make necessary
library configurations or something, which i'm pretty
much clueless about). so i just went with typing the
whole directory where postgis.sql was located. anyway,
this is what happened:

$ psql -d  postgisdb -f
/usr/local/pgsql/share/postgis.sql
BEGIN
        message
------------------------
 PL/PgSQL is installed.
(1 row)

psql:/usr/local/pgsql/share/postgis.sql:37: NOTICE: 
type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:/usr/local/pgsql/share/postgis.sql:37: ERROR: 
could not load library "/usr/local/pgsql/
lib/libpostgis.so.0.8": libproj.so.0: cannot open
shared object file: No such file or directo
ry
psql:/usr/local/pgsql/share/postgis.sql:42: ERROR: 
current transaction is aborted, commands
ignored until end of transaction block
psql:/usr/local/pgsql/share/postgis.sql:50: ERROR: 
current transaction is aborted, commands
ignored until end of transaction block
psql:/usr/local/pgsql/share/postgis.sql:58: ERROR: 
current transaction is aborted, commands
ignored until end of transaction block
psql:/usr/local/pgsql/share/postgis.sql:63: ERROR: 
current transaction is aborted, commands
ignored until end of transaction block
psql:/usr/local/pgsql/share/postgis.sql:70: ERROR: 
current transaction is aborted, commands
ignored until end of transaction block
psql:/usr/local/pgsql/share/postgis.sql:78: ERROR: 
current transaction is aborted, commands
ignored until end of transaction block
psql:/usr/local/pgsql/share/postgis.sql:83: ERROR: 
current transaction is aborted, commands
ignored until end of transaction block
psql:/usr/local/pgsql/share/postgis.sql:90: ERROR: 
current transaction is aborted, commands
ignored until end of transaction block
psql:/usr/local/pgsql/share/postgis.sql:98: ERROR: 
current transaction is aborted, commands
ignored until end of transaction block
.
.
.
.
(a little less than a hundred more lines here of the
same)
.
.
.


i really hope someone could help. thanx in advance! :)


-Myk


	
		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail