[postgis-users] Problems creating postgis extension

[Stephen Woodbridge]

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