[postgis-users] Problems creating postgis extension

[Stephen Woodbridge]

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
>