[postgis-users] Problems creating postgis extension
Martin Moore
martin.moore at avbrief.com
Tue May 30 12:42:41 PDT 2017
ld.so.conf.d# ldd /usr/lib/postgresql/9.6/lib/postgis_topology-2.3.so
linux-vdso.so.1 (0x00007ffe80def000)
libgeos_c.so.1 => /usr/lib/libgeos_c.so.1 (0x00007f267ac1f000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f267a874000)
libgeos-3.4.2.so => /usr/lib/libgeos-3.4.2.so (0x00007f267a4cc000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f267a1c1000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f2679ec0000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f2679ca9000)
/lib64/ld-linux-x86-64.so.2 (0x000055fafb1f0000)
ld.so.conf.d# ldd /usr/lib/postgresql/9.6/lib/postgis-2.3.so
linux-vdso.so.1 (0x00007ffd42f59000)
liblwgeom-2.3.so.0 => /usr/lib/liblwgeom-2.3.so.0 (0x00007f2991122000)
libgeos_c.so.1 => /usr/lib/libgeos_c.so.1 (0x00007f2990efb000)
libproj.so.0 => /usr/local/lib/libproj.so.0 (0x00007f2990cb9000)
libjson-c.so.2 => /lib/x86_64-linux-gnu/libjson-c.so.2 (0x00007f2990aae000)
libxml2.so.2 => /usr/lib/x86_64-linux-gnu/libxml2.so.2 (0x00007f2990747000)
libSFCGAL.so.1 => /usr/lib/x86_64-linux-gnu/libSFCGAL.so.1 (0x00007f298fd08000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f298f95d000)
libgeos-3.4.2.so => /usr/lib/libgeos-3.4.2.so (0x00007f298f5b6000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x00007f298f2aa000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f298efa9000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f298ed93000)
libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f298eb8e000)
libz.so.1 => /lib/x86_64-linux-gnu/libz.so.1 (0x00007f298e973000)
liblzma.so.5 => /lib/x86_64-linux-gnu/liblzma.so.5 (0x00007f298e750000)
libCGAL.so.10 => /usr/lib/libCGAL.so.10 (0x00007f298e525000)
libCGAL_Core.so.10 => /usr/lib/libCGAL_Core.so.10 (0x00007f298e2ec000)
libmpfr.so.4 => /usr/lib/x86_64-linux-gnu/libmpfr.so.4 (0x00007f298e089000)
libgmp.so.10 => /usr/lib/x86_64-linux-gnu/libgmp.so.10 (0x00007f298de05000)
libosgDB.so.100 => /usr/lib/x86_64-linux-gnu/libosgDB.so.100 (0x00007f298daec000)
libosgUtil.so.100 => /usr/lib/x86_64-linux-gnu/libosgUtil.so.100 (0x00007f298d712000)
libosg.so.100 => /usr/lib/x86_64-linux-gnu/libosg.so.100 (0x00007f298d210000)
libOpenThreads.so.20 => /usr/lib/x86_64-linux-gnu/libOpenThreads.so.20 (0x00007f298d008000)
libboost_program_options.so.1.55.0 => /usr/lib/x86_64-linux-gnu/libboost_program_options.so.1.55.0 (0x00007f298cd90000)
libboost_chrono.so.1.55.0 => /usr/lib/x86_64-linux-gnu/libboost_chrono.so.1.55.0 (0x00007f298cb87000)
libboost_filesystem.so.1.55.0 => /usr/lib/x86_64-linux-gnu/libboost_filesystem.so.1.55.0 (0x00007f298c96f000)
libboost_timer.so.1.55.0 => /usr/lib/x86_64-linux-gnu/libboost_timer.so.1.55.0 (0x00007f298c76a000)
libboost_unit_test_framework.so.1.55.0 => /usr/lib/x86_64-linux-gnu/libboost_unit_test_framework.so.1.55.0 (0x00007f298c4bb000)
libboost_date_time.so.1.55.0 => /usr/lib/x86_64-linux-gnu/libboost_date_time.so.1.55.0 (0x00007f298c2a9000)
libboost_thread.so.1.55.0 => /usr/lib/x86_64-linux-gnu/libboost_thread.so.1.55.0 (0x00007f298c08e000)
libboost_system.so.1.55.0 => /usr/lib/x86_64-linux-gnu/libboost_system.so.1.55.0 (0x00007f298be89000)
libboost_serialization.so.1.55.0 => /usr/lib/x86_64-linux-gnu/libboost_serialization.so.1.55.0 (0x00007f298bc17000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f298b9fa000)
/lib64/ld-linux-x86-64.so.2 (0x0000563ba1460000)
libGL.so.1 => /usr/lib/x86_64-linux-gnu/libGL.so.1 (0x00007f298b75f000)
librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f298b557000)
libexpat.so.1 => /lib/x86_64-linux-gnu/libexpat.so.1 (0x00007f298b32d000)
libglapi.so.0 => /usr/lib/x86_64-linux-gnu/libglapi.so.0 (0x00007f298b103000)
libXext.so.6 => /usr/lib/x86_64-linux-gnu/libXext.so.6 (0x00007f298aef0000)
libXdamage.so.1 => /usr/lib/x86_64-linux-gnu/libXdamage.so.1 (0x00007f298aced000)
libXfixes.so.3 => /usr/lib/x86_64-linux-gnu/libXfixes.so.3 (0x00007f298aae7000)
libX11-xcb.so.1 => /usr/lib/x86_64-linux-gnu/libX11-xcb.so.1 (0x00007f298a8e4000)
libX11.so.6 => /usr/lib/x86_64-linux-gnu/libX11.so.6 (0x00007f298a5a1000)
libxcb-glx.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-glx.so.0 (0x00007f298a388000)
libxcb-dri2.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-dri2.so.0 (0x00007f298a182000)
libxcb-dri3.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-dri3.so.0 (0x00007f2989f7f000)
libxcb-present.so.0 => /usr/lib/x86_64-linux-gnu/libxcb-present.so.0 (0x00007f2989d7c000)
libxcb-sync.so.1 => /usr/lib/x86_64-linux-gnu/libxcb-sync.so.1 (0x00007f2989b74000)
libxcb.so.1 => /usr/lib/x86_64-linux-gnu/libxcb.so.1 (0x00007f2989952000)
libxshmfence.so.1 => /usr/lib/x86_64-linux-gnu/libxshmfence.so.1 (0x00007f2989750000)
libXxf86vm.so.1 => /usr/lib/x86_64-linux-gnu/libXxf86vm.so.1 (0x00007f2989549000)
libdrm.so.2 => /usr/lib/x86_64-linux-gnu/libdrm.so.2 (0x00007f298933c000)
libXau.so.6 => /usr/lib/x86_64-linux-gnu/libXau.so.6 (0x00007f2989137000)
libXdmcp.so.6 => /usr/lib/x86_64-linux-gnu/libXdmcp.so.6 (0x00007f2988f32000)
On 30/05/2017, 20:39, "postgis-users on behalf of Stephen Woodbridge" <postgis-users-bounces at lists.osgeo.org on behalf of woodbri at swoodbridge.com> wrote:
What does ldd say for your library. I'm on Ubuntu and had installed pg
9.6 yet, but for 9.5 I have this:
$ ldd /usr/lib/postgresql/9.5/lib/postgis_topology-2.3.so
linux-vdso.so.1 => (0x00007ffdb19fb000)
libgeos_c.so.1 => /usr/lib/libgeos_c.so.1 (0x00007f61b6e3c000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f61b6a74000)
libgeos-3.4.2.so => /usr/lib/libgeos-3.4.2.so (0x00007f61b66ef000)
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6
(0x00007f61b63eb000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1
(0x00007f61b61d5000)
/lib64/ld-linux-x86-64.so.2 (0x00007f61b72d7000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f61b5ece000)
On 5/30/2017 3:34 PM, Stephen Woodbridge wrote:
> On 5/30/2017 3:22 PM, Martin Moore wrote:
>> Thanks Steve – nothing returned.
>>
>> I’m guessing that’s wrong!
>
> No it doesn't return anything. It just makes sure the library is known
> to the dynamic loader. Hmm, I reread your message, you are missing a
> symbol, so it found the library ok.
>
> This sounds like a packaging issue of some kind. You should make sure
> that you are getting proj4, postgresql and postgis all from the same
> repository and not mixing and matching.
>
> -Steve
>
>
>> On 30/05/2017, 20:19, "postgis-users on behalf of Stephen Woodbridge"
>> <postgis-users-bounces at lists.osgeo.org on behalf of
>> woodbri at swoodbridge.com> wrote:
>>
>> Try:
>> sudo ldconfig
>> and see if the helps.
>> -Steve
>> On 5/30/2017 2:12 PM, Martin Moore wrote:
>> > Hi,
>> >
>> > On Debian Jessie 64bit, postgis 2.3, postgres 9.6 (both
>> installed using
>> > apt-get)
>> >
>> > I can’t create postgis extension
>> >
>> > psql -d mydb -c "CREATE EXTENSION postgis;"
>> >
>> > ERROR: could not load library
>> > "/usr/lib/postgresql/9.6/lib/postgis-2.3.so":
>> > /usr/lib/postgresql/9.6/lib/postgis-2.3.so: undefined symbol:
>> > pj_get_spheroid_defn
>> >
>> > But it is there:
>> >
>> > objdump -t -T /usr/lib/postgresql/9.6/lib/postgis-2.3.so |
>> grep defn
>> >
>> > 0000000000000000 DF *UND* 0000000000000000
>> > pj_get_spheroid_defn
>> >
>> > It appears to have proj 4.8
>> >
>> > ii libproj0 4.8.0-5
>> > amd64 Cartographic projection library
>> >
>> > ii proj-bin 4.8.0-5
>> > amd64 Cartographic projection library (tools)
>> >
>> > ii proj-data 4.8.0-5
>> > amd64 Cartographic projection filter and
>> library (datum
>> > package)
>> >
>> > I’m not a Linux guru and this has me stumped!
>> >
>> > What am I missing?
>> >
>> > Thanks,
>> >
>> > Martin.
>> >
>> >
>> >
>> > _______________________________________________
>> > postgis-users mailing list
>> > postgis-users at lists.osgeo.org
>> > https://lists.osgeo.org/mailman/listinfo/postgis-users
>> >
>> ---
>> This email has been checked for viruses by Avast antivirus software.
>> https://www.avast.com/antivirus
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
More information about the postgis-users
mailing list