[postgis-users] Problems creating postgis extension

[Martin Moore]

I didn’t have proj4 (libgeo-proj4-perl) – now installed. Everything was installed from Debian repos.

Postgres restarted and same problem.





On 30/05/2017, 20:34, "postgis-users on behalf of Stephen Woodbridge" <postgis-users-bounces at lists.osgeo.org on behalf of woodbri at swoodbridge.com> 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