[postgis-users] Problems creating postgis extension

[Stephen Woodbridge]

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