[ gpsdrive ] postgresql & postgis integration

[Hamish]

Hamish:
> > can you try:
> >   ldd /usr/lib/postgresql/8.3/lib/liblwgeom.so

Chris:
> chris123 at kubuntu8:~$ ldd
> /usr/lib/postgresql/8.3/lib/liblwgeom.so
>         linux-gate.so.1 =>  (0xb7f75000)
>         libgeos_c.so.1 => /usr/lib/libgeos_c.so.1 (0xb7ee4000)
>         libproj.so.0 => /usr/local/lib/libproj.so.0 (0xb7eb2000)

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

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

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.

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,...


good luck,
Hamish