[postgis-users] postgis installation on current Postgresql (8.1) database (on Debian)

[TECHER David]

Hi Assad

As I said as anwser in another mail

You need to have geos' libdir in your LIBRARY PATH

echo $(geos-config --prefix)/lib >> /etc/ld.so.conf
ldconfig -v | grep libgeos

U have to see to appear about libgeos

then drop your database

psql -d template1 -U <yourusernameforpg> "drop database mingle"

or

dropdb mingle

createdb mingle
createlang plpgsql mingle
psql -d mingle -f lwpostgis.sql


Assad Jarrahian a écrit :

>David,
>   That worked and it all installed okay!
>  so after following directions on the postgis page:
>
>createlang plpgsql yourtestdatabase
>psql -d yourtestdatabase -f lwpostgis.sql
>psql -d yourtestdatabase -f spatial_ref_sys.sql
>
>when I do:
>psql -d mingle -f lwpostgis.sql
>
>I get this:
>psql:lwpostgis.sql:39: ERROR:  could not load library
>"/usr/lib/postgresql/8.1/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
>
>I look to see if /usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1 exists
>and it does! What I cannot find is libgeos_c.so.1 ...  but ...
>
>jarraa at proximity:/usr/lib/postgresql/8.1/lib$ fgrep  "libgeos_c.so.1" *
>Binary file liblwgeom.so matches
>Binary file liblwgeom.so.1 matches
>Binary file liblwgeom.so.1.1 matches
>
>any clue?
>
>much thanks.
>-assad
>
>
>On 1/13/06, TECHER David <davidtecher at yahoo.fr> wrote:
>  
>
>><cut>
>>
>>    
>>
>>>>I took a closer look. The directory /usr/include/postgresql/ exists
>>>>and postgres.h is in that directory.
>>>>
>>>>There is no 8.1 directory.
>>>>How do I mend the problem (tell pg-config that the directory is somewhere else)
>>>>
>>>>much thanks and sorry for the initial lookover of the file existing.
>>>>-assad
>>>>
>>>>
>>>>        
>>>>
>>Are U sure?
>>
>>Because
>>
>>bremko:~# apt-cache search postgresql | grep 8.1
>>[....]
>>postgresql-8.1 - object-relational SQL database, version 8.1 server
>>[....]
>>postgresql-server-dev-8.1 - development files for PostgreSQL 8.1
>>server-side programming
>>bremko:~# apt-get -b source postgresql-8.1
>>bremko:~# dpkg -c postgresql-server-dev-8.1_8.1.0-3_i386.deb | grep
>>postgres.h
>>-rw-r--r-- root/root 14253 2006-01-13 21:36:02
>>./usr/include/postgresql/8.1/server/postgres.h
>>
>>so why not try to do then
>>
>>dpkg -i postgresql-server-dev-8.1_8.1.0-3_i386.deb ???
>>
>>
>>
>>
>>
>>___________________________________________________________________________
>>Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs exceptionnels pour appeler la France et l'international.
>>Téléchargez sur http://fr.messenger.yahoo.com
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>    
>>
>
>  
>


	
	
		
___________________________________________________________________________ 
Nouveau : téléphonez moins cher avec Yahoo! Messenger. Appelez le monde entier à partir de 0,012 €/minute ! 
Téléchargez sur http://fr.messenger.yahoo.com