[ gpsdrive ] postgresql & postgis integration [Off topic]

[Hamish]

Chris:
> I deleted the libs in /usr/local/lib so cant tell what the
> source of these were.

'dpkg -S <filename>' checks the package manifest database, so it should work even if the file is removed.

other ways to check:

cd /var/lib/dpkg/info/
cat postgresql-8.3-postgis.list


# find what package(s) a file belongs to, even if the pkg is not installed
#  (output given is for Debian/etch)
$ apt-file search liblwgeom.so
postgresql-8.1-postgis: usr/lib/postgresql/8.1/lib/liblwgeom.so
....

# list the files provided by that package
$ apt-file list postgresql-8.1-postgis
postgresql-8.1-postgis: usr/lib/postgresql/8.1/lib/liblwgeom.so
....

If the Ubuntu postgis package is broken I think it is important they know.

I do not know if the library is originally pointed to be in /usr/local if it will fall back on the ld search path (/usr/lib/) if not found in /usr/local/ and thus still work. That way a bad path would only be spotted when it exists in both places and uses the wrong one. (???)


> Thanks as I think this is important as I struggled with
> this for almost 3 weeks 2 hrs a night and no info source
> other then Hamish could point me towards a solution.

These sorts of problems are a fairly regular FAQ on the GRASS list, I'm just regurgitating.


> Google was not that helpfull either. 

google indexes these archives, so hopefully in future it will be.


Hamish