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

Sat Jan 14 08:20:57 PST 2006

Thanks for yoru help alex and david.
Since I was half way through installing from the source, I still kept
at it and it  finally worked.

-Assad

On 1/14/06, alex bodnaru <alexbodn at 012.net.il> wrote:
> 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
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>