[postgis-users] Problems creating postgis extension

[Martin Moore]

Thanks Steve – nothing returned.

I’m guessing that’s wrong!



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