[postgis-users] psql:lwpostgis.sql:48: ERROR: could not load library "/usr/local/pgsql/lib/liblwgeom.so.1.1": /usr/local/pgsql/lib/liblwgeom.so.1.1: undefined symbol: pj_transform

[Mark Cave-Ayland]

On Mon, 2007-04-16 at 17:50 +0200, Stefan Hahmann wrote:
> Hi all,
> 
> The following problems occurs when i want to execute: psql -d mydatabase -f lwpostgis.sql
> 
> "psql:lwpostgis.sql:48: ERROR:  could not load library "/usr/local/pgsql/lib/liblwgeom.so.1.1": /usr/local/pgsql/lib/liblwgeom.so.1.1: undefined symbol: pj_transform"
> 
> I have already installed postgresql, postgis, proj.4, geos.
> To me that seems to be a problem with the proj.4 support.
> 
> If that helps: ldd /usr/local/pgsql/lib/liblwgeom.so.1.1 /usr/local/lib/libgeos_c.so.1
> 
> has the following result:
> 
> /usr/local/pgsql/lib/liblwgeom.so.1.1:
>                 libgeos_c.so.1 => /usr/local/lib/libgeos_c.so.1 (0x4007f000)
>         libc.so.6 => /lib/tls/libc.so.6 (0x4008f000)
>         libgeos.so.2 => /usr/local/lib/libgeos.so.2 (0x401c4000)
>         libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x402c2000)
>         libm.so.6 => /lib/tls/libm.so.6 (0x4037c000)
>         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x4039e000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
> /usr/local/lib/libgeos_c.so.1:
>                 libgeos.so.2 => /usr/local/lib/libgeos.so.2 (0x40010000)
>         libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0x4010f000)
>         libm.so.6 => /lib/tls/libm.so.6 (0x401cf000)
>         libc.so.6 => /lib/tls/libc.so.6 (0x401f1000)
>         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x40326000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
> 
> 
> Thanks in advance.


Hi Stefen,

Well that's strange: a PostGIS with PROJ.4 support should show a
reference to libproj.so in the above output. It almost looks as if
you've compiled PostGIS locally without PROJ.4 support but using a
lwpostgis.sql file from a PostGIS compiled with PROJ.4 support. Can you
please show the complete list of steps / output from ./configure
onwards?


Kind regards,

Mark.