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

[Assad Jarrahian]

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
>