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

[alex bodnaru]

hi,

good to hear.

since assad is using debian, i have naturally offered him to use a
debian package.

thanks anyway,

alex

TECHER David wrote:
> 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 €/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 €/minute !
>>> 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