Thread

  1. BUG #18704: Installing postgis fails due to depencies

    PG Bug reporting form <noreply@postgresql.org> — 2024-11-13T15:39:12Z

    The following bug has been logged on the website:
    
    Bug reference:      18704
    Logged by:          Tony Smith
    Email address:      tony.smith@enterprisedb.com
    PostgreSQL version: 14.13
    Operating system:   SLES 15 SP6
    Description:        
    
    Eg
    
    If you try to install Postgis35_14
    
    zypper install postgis35_14
    Loading repository data...
    Reading installed packages...
    Resolving package dependencies...
    
    Problem: 1: nothing provides 'libnetcdf.so.19()(64bit)' needed by the to be
    installed gdal39-libs-3.9.2-1PGDG.sles15.x86_64
     Solution 1: do not install postgis35_14-3.5.0-1PGDG.sles15.x86_64
     Solution 2: break gdal39-libs-3.9.2-1PGDG.sles15.x86_64 by ignoring some of
    its dependencies
    
    It doesn't matter which version to be fair.
    
    A workaround is to use the
    https://ftp.lysator.liu.se/pub/opensuse/tumbleweed/repo/oss/ repository
    
    The install will then work. Essentially it loks like the packages have been
    compiled in a Opensuse Tumbleweed environment. It would be better is they
    were  compiled against package versions available in SLES 15
    
    
  2. Re: BUG #18704: Installing postgis fails due to depencies

    Devrim Gündüz <devrim@gunduz.org> — 2024-12-30T19:40:12Z

    Hi Tony,
    
    On Wed, 2024-11-13 at 15:39 +0000, PG Bug reporting form wrote:
    > The following bug has been logged on the website:
    > 
    > Bug reference:      18704
    > Logged by:          Tony Smith
    > Email address:      tony.smith@enterprisedb.com
    > PostgreSQL version: 14.13
    > Operating system:   SLES 15 SP6
    > Description:        
    > 
    > Eg
    > 
    > If you try to install Postgis35_14
    > 
    > zypper install postgis35_14
    > Loading repository data...
    > Reading installed packages...
    > Resolving package dependencies...
    > 
    > Problem: 1: nothing provides 'libnetcdf.so.19()(64bit)' needed by the
    > to be
    > installed gdal39-libs-3.9.2-1PGDG.sles15.x86_64
    >  Solution 1: do not install postgis35_14-3.5.0-1PGDG.sles15.x86_64
    >  Solution 2: break gdal39-libs-3.9.2-1PGDG.sles15.x86_64 by ignoring
    > some of
    > its dependencies
    > 
    > It doesn't matter which version to be fair.
    > 
    > A workaround is to use the
    > https://ftp.lysator.liu.se/pub/opensuse/tumbleweed/repo/oss/ repositor
    > y
    > 
    > The install will then work. Essentially it loks like the packages have
    > been
    > compiled in a Opensuse Tumbleweed environment. It would be better is
    > they
    > were  compiled against package versions available in SLES 15
    > 
    
    I just drafted a mini howto for installing PostGIS on SLES 15:
    
    https://zypp.postgresql.org/extensions/postgis/
    
    -HTH
    
    Regards,
    -- 
    Devrim Gündüz
    Open Source Solution Architect, PostgreSQL Major Contributor
    Twitter: @DevrimGunduz , @DevrimGunduzTR