[ gpsdrive ] postgresql & postgis integration

[Chris H]

On Friday 06 June 2008 10:23:52 Hamish wrote:

> ^^^^^^^ do you also have the ubuntu proj package installed??
>         do you actually have a libproj.so in /usr/local/lib/ ?

Interesting. I have it in both locations. Ubuntu proj is installed. 

> ie both a version in /usr/lib/ and another version in /usr/local/lib which
> could conflict??

As I have it in both locations where is the proper location for its residence. 

> did you compile liblwgeom.so yourself? it may be that the packager's system
> had a copy of proj in their /usr/local/lib and it trickled down to you that
> way.

No. Perhaps its the latter which could make sense. 

> If you do have libproj in /usr/local/lib and the ubuntu pacakge is not
> installed (ie you built it yourself) you can try adding /usr/local/lib to
> /etc/ld.so.cond and running (as root) ldconfig to get that in the library
> search path/cache.
>
> --or "export LD_LIBRARY_PATH=/usr/local/lib" for a temporary fix--
>
> >         libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0xb7d62000)
> >         libgeos.so.2 => /usr/lib/libgeos.so.2 (0xb7c54000)
> >         libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0xb7b61000)
> >         libm.so.6 => /lib/tls/i686/cmov/libm.so.6 (0xb7b3c000)
> >         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7b31000)
> >         /lib/ld-linux.so.2 (0xb7f76000)
> >
> >
> >
> > The advise I got from the postgis list is to step through
> > /lwpostgis.sql one line at a time manually and see what happens.
> > Not sure I want to try that at present
>
> you can do the trick of stopping the action half way, see if it breaks,
> then based on that split the remaining side in half again, etc, etc. until
> you find the line.  that is a much much faster way than starting at 1 then
> stepping through 2,3,4,5,...

deal with this part later. 

TKS


-- 
/ch