<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Alex<br>
<br>
it seems that me and assad haven't post my mail to the postgis-list
(attahched at the end :) )<br>
<br>
Assad succeeded to install everything<br>
<br>
<br>
alex bodnaru a écrit :
<blockquote cite="mid43C85D81.9010309@alex3" type="cite">
<pre wrap="">assad,
your ./configure output seems a little wird for a clean postgresql sarge
installation.
the procedure below will possibly help. if still in problem, you might
need to have a better backported postgresql for sarge, or upgrade debian.
please apply this diff to the *clean* postgis source:
cd postgis_source_root
zcat the_attached_file | patch -p1
# you should have ./debian subdirectory in postgis_source_root
chmod ug+x debian/rules
dpkg-buildpackage -rfakeroot
good luck,
alex
</pre>
</blockquote>
<div class="moz-text-plain" wrap="true" graphical-quote="true"
style="font-family: -moz-fixed; font-size: 12px;" lang="x-western">
<pre wrap=""><cut>
it worked!! thanks David.
One more question, how do I go about installing it on a db that
already exists and has data in it. Should I just do a pg_dump, then
drop the db, then install postgis and then do a pg_restore on it?
much thanks!
-assad
On 1/13/06, TECHER David <a class="moz-txt-link-rfc2396E"
href="mailto:davidtecher@yahoo.fr"><davidtecher@yahoo.fr></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">> </span>Just put /usr/local/lib at the end of the file /etc/ld.so.conf
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>then
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>run
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>ldconfig
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>that's what I mean by "
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>echo $(geos-config --prefix)/lib >> /etc/ld.so.conf
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>"
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>Assad Jarrahian a écrit :
<span class="moz-txt-citetags">></span>
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">> >></span>As I said as anwser in another mail
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>You need to have geos' libdir in your LIBRARY PATH
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>echo $(geos-config --prefix)/lib >> /etc/ld.so.conf
<span class="moz-txt-citetags">> >></span>ldconfig -v | grep libgeos
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>U have to see to appear about libgeos
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>
</pre>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">> ></span>
<span class="moz-txt-citetags">> ></span>I am not following ... I looked at your past emails on this thread and
<span class="moz-txt-citetags">> ></span>could not find anything about geos libdir.
<span class="moz-txt-citetags">> ></span>
<span class="moz-txt-citetags">> ></span>I installed <b
class="moz-txt-star"><span class="moz-txt-tag">*</span>all<span
class="moz-txt-tag">*</span></b> the packages you told me to. And got postgis to be installed.
<span class="moz-txt-citetags">> ></span>
<span class="moz-txt-citetags">> ></span>"You need to have geos' libdir in your LIBRARY PATH"
<span class="moz-txt-citetags">> ></span>
<span class="moz-txt-citetags">> ></span>How do I that do that?
<span class="moz-txt-citetags">> ></span>I did the following
<span class="moz-txt-citetags">> ></span>echo $(geos-config --prefix)/lib >> /etc/ld.so.conf ldconfig -v
<span class="moz-txt-citetags">> ></span>...and nothing got outputed.
<span class="moz-txt-citetags">> ></span>
<span class="moz-txt-citetags">> ></span>please explain steps to add geos' libdir to my LIBRARY PATH
<span class="moz-txt-citetags">> ></span>thanks
<span class="moz-txt-citetags">> ></span>
<span class="moz-txt-citetags">> ></span>-assad
<span class="moz-txt-citetags">> ></span>
<span class="moz-txt-citetags">> ></span>
<span class="moz-txt-citetags">> ></span>
<span class="moz-txt-citetags">> ></span>
</pre>
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">> >></span>then drop your database
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>psql -d template1 -U <yourusernameforpg> "drop database mingle"
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>or
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>dropdb mingle
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>createdb mingle
<span class="moz-txt-citetags">> >></span>createlang plpgsql mingle
<span class="moz-txt-citetags">> >></span>psql -d mingle -f lwpostgis.sql
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>Assad Jarrahian a écrit :
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>
</pre>
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">> >>></span>David,
<span class="moz-txt-citetags">> >>> </span> That worked and it all installed okay!
<span class="moz-txt-citetags">> >>> </span>so after following directions on the postgis page:
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>createlang plpgsql yourtestdatabase
<span class="moz-txt-citetags">> >>></span>psql -d yourtestdatabase -f lwpostgis.sql
<span class="moz-txt-citetags">> >>></span>psql -d yourtestdatabase -f spatial_ref_sys.sql
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>when I do:
<span class="moz-txt-citetags">> >>></span>psql -d mingle -f lwpostgis.sql
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>I get this:
<span class="moz-txt-citetags">> >>></span>psql:lwpostgis.sql:39: ERROR: could not load library
<span class="moz-txt-citetags">> >>></span>"/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1": libgeos_c.so.1: cannot
<span class="moz-txt-citetags">> >>></span>open shared object file: No such file or directory
<span class="moz-txt-citetags">> >>></span>psql:lwpostgis.sql:44: ERROR: current transaction is aborted,
<span class="moz-txt-citetags">> >>></span>commands ignored until end of transaction block
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>I look to see if /usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1 exists
<span class="moz-txt-citetags">> >>></span>and it does! What I cannot find is libgeos_c.so.1 ... but ...
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span><a
class="moz-txt-link-abbreviated"
href="mailto:jarraa@proximity:/usr/lib/postgresql/8.1/lib$">jarraa@proximity:/usr/lib/postgresql/8.1/lib$</a> fgrep "libgeos_c.so.1" *
<span class="moz-txt-citetags">> >>></span>Binary file liblwgeom.so matches
<span class="moz-txt-citetags">> >>></span>Binary file liblwgeom.so.1 matches
<span class="moz-txt-citetags">> >>></span>Binary file liblwgeom.so.1.1 matches
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>any clue?
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>much thanks.
<span class="moz-txt-citetags">> >>></span>-assad
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>On 1/13/06, TECHER David <a
class="moz-txt-link-rfc2396E" href="mailto:davidtecher@yahoo.fr"><davidtecher@yahoo.fr></a> wrote:
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>
</pre>
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">> >>>></span><cut>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap=""><span class="moz-txt-citetags">> >>>>>></span>I took a closer look. The directory <i
class="moz-txt-slash"><span class="moz-txt-tag">/</span>usr/include/postgresql<span
class="moz-txt-tag">/</span></i> exists
<span class="moz-txt-citetags">> >>>>>></span>and postgres.h is in that directory.
<span class="moz-txt-citetags">> >>>>>></span>
<span class="moz-txt-citetags">> >>>>>></span>There is no 8.1 directory.
<span class="moz-txt-citetags">> >>>>>></span>How do I mend the problem (tell pg-config that the directory is somewhere else)
<span class="moz-txt-citetags">> >>>>>></span>
<span class="moz-txt-citetags">> >>>>>></span>much thanks and sorry for the initial lookover of the file existing.
<span class="moz-txt-citetags">> >>>>>></span>-assad
<span class="moz-txt-citetags">> >>>>>></span>
<span class="moz-txt-citetags">> >>>>>></span>
<span class="moz-txt-citetags">> >>>>>></span>
<span class="moz-txt-citetags">> >>>>>></span>
<span class="moz-txt-citetags">> >>>>>></span>
<span class="moz-txt-citetags">> >>>>>></span>
</pre>
</blockquote>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">> >>>></span>Are U sure?
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>Because
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>bremko:~# apt-cache search postgresql | grep 8.1
<span class="moz-txt-citetags">> >>>></span>[....]
<span class="moz-txt-citetags">> >>>></span>postgresql-8.1 - object-relational SQL database, version 8.1 server
<span class="moz-txt-citetags">> >>>></span>[....]
<span class="moz-txt-citetags">> >>>></span>postgresql-server-dev-8.1 - development files for PostgreSQL 8.1
<span class="moz-txt-citetags">> >>>></span>server-side programming
<span class="moz-txt-citetags">> >>>></span>bremko:~# apt-get -b source postgresql-8.1
<span class="moz-txt-citetags">> >>>></span>bremko:~# dpkg -c postgresql-server-dev-8.1_8.1.0-3_i386.deb | grep
<span class="moz-txt-citetags">> >>>></span>postgres.h
<span class="moz-txt-citetags">> >>>></span>-rw-r--r-- root/root 14253 2006-01-13 21:36:02
<span class="moz-txt-citetags">> >>>></span>./usr/include/postgresql/8.1/server/postgres.h
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>so why not try to do then
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>dpkg -i postgresql-server-dev-8.1_8.1.0-3_i386.deb ???
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>___________________________________________________________________________
<span class="moz-txt-citetags">> >>>></span>Nouveau : téléphonez moins cher avec Yahoo! Messenger ! Découvez les tarifs exceptionnels pour appeler la France et l'international.
<span class="moz-txt-citetags">> >>>></span>Téléchargez sur <a
class="moz-txt-link-freetext" href="http://fr.messenger.yahoo.com">http://fr.messenger.yahoo.com</a>
<span class="moz-txt-citetags">> >>>></span>_______________________________________________
<span class="moz-txt-citetags">> >>>></span>postgis-users mailing list
<span class="moz-txt-citetags">> >>>></span><a
class="moz-txt-link-abbreviated"
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<span class="moz-txt-citetags">> >>>></span><a
class="moz-txt-link-freetext"
href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
<span class="moz-txt-citetags">> >>>></span>
</pre>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>
<span class="moz-txt-citetags">> >>></span>
</pre>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>___________________________________________________________________________
<span class="moz-txt-citetags">> >></span>Nouveau : téléphonez moins cher avec Yahoo! Messenger. Appelez le monde entier à partir de 0,012 €/minute !
<span class="moz-txt-citetags">> >></span>Téléchargez sur <a
class="moz-txt-link-freetext" href="http://fr.messenger.yahoo.com">http://fr.messenger.yahoo.com</a>
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>
<span class="moz-txt-citetags">> >></span>
</pre>
</blockquote>
</blockquote>
<pre wrap=""><span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">> </span>___________________________________________________________________________
<span class="moz-txt-citetags">> </span>Nouveau : téléphonez moins cher avec Yahoo! Messenger. Appelez le monde entier à partir de 0,012 €/minute !
<span class="moz-txt-citetags">> </span>Téléchargez sur <a
class="moz-txt-link-freetext" href="http://fr.messenger.yahoo.com">http://fr.messenger.yahoo.com</a>
<span class="moz-txt-citetags">></span>
<span class="moz-txt-citetags">></span>
</pre>
</blockquote>
</div>
</body>
</html>