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

[TECHER David]

Hi Alex

it seems that me and assad haven't post my mail to the postgis-list
(attahched at the end :) )

Assad succeeded to install everything


alex bodnaru a écrit :

>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
>
>  
>
<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 <davidtecher at yahoo.fr> wrote:

>> Just put /usr/local/lib at the end of the file /etc/ld.so.conf
>>
>> then
>>
>> run
>>
>> ldconfig
>>
>> that's what  I mean by "
>>
>> echo $(geos-config --prefix)/lib >> /etc/ld.so.conf
>>
>> "
>>
>>
>>
>> Assad Jarrahian a écrit :
>>
>  
>
>>>> >>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
>>>> >>
>>>> >>
>>>      
>>>
>>> >
>>> >I am not following ... I looked at your past emails on this thread and
>>> >could not find anything about geos libdir.
>>> >
>>> >I installed *all* the packages you told me to. And got postgis to be installed.
>>> >
>>> >"You need to have geos' libdir in your LIBRARY PATH"
>>> >
>>> >How do I that do that?
>>> >I did the following
>>> >echo $(geos-config --prefix)/lib >> /etc/ld.so.conf ldconfig -v
>>> >...and nothing got outputed.
>>> >
>>> >please explain steps to add  geos' libdir to my LIBRARY PATH
>>> >thanks
>>> >
>>> >-assad
>>> >
>>> >
>>> >
>>> >
>>    
>>
>>>> >>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 EUR/minute !
>>>> >>Téléchargez sur http://fr.messenger.yahoo.com
>>>> >>
>>>> >>
>>>> >>
>>>> >>
>>>      
>>>
>>
>>
>>
>>
>>
>> ___________________________________________________________________________
>> Nouveau : téléphonez moins cher avec Yahoo! Messenger. Appelez le monde entier à partir de 0,012 EUR/minute !
>> Téléchargez sur http://fr.messenger.yahoo.com
>>
>>
>  
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060114/f1801fd9/attachment.html>