Re: BUG #16859: PostGIS 30 and 31 installation on SLES15 SP2 missing package SFCGAL or gmp - Mailing list pgsql-bugs

Hi,

Thanks for the report. Looks like I fixed the gmp issue in the spec
files already, but did not update the repo.

SFCGAL issue was about a sync problem, which I fixed (which affected a
few more packages). Sorry for the inconvenience.

Used this opportunity to release 3.1.1 on SLES 15 as well. The new
packages (3.1.1-1 and 3.0.3-5) are now in the repo. Please run

zypper refresh

to make sure that the metadata is up2date.

Let me know if you see more issues.

Regards, Devrim

On Wed, 2021-02-10 at 07:24 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference:      16859
> Logged by:          heiko kaempf
> Email address:      h.kaempf@owl-it.de
> PostgreSQL version: 12.0
> Operating system:   SUSE Linux Enterprise Server 15 SP2
> Description:       
>
> Dear PostgreSQL developer team,
>
> we have just incuded repositories of PostgreSQL 11, 12 and 13 for
> SLES15 SP2 to our SUSE Manager environment from the following
> download
> links:
> https://download.postgresql.org/pub/repos/zypp/11/suse/sles-15.2-x86_64/
> https://download.postgresql.org/pub/repos/zypp/12/suse/sles-15.2-x86_64/
> https://download.postgresql.org/pub/repos/zypp/13/suse/sles-15.2-x86_64/
>
> When trying to install PostGIS version 30 or 31 for PostgreSQL 11, 12
> or
> 13
> there is a dependency to missing packages SFCGAL or gmp.
>
> Please find below detailed version of our Linux version and the error
> messages:
>
> # cat /etc/os-release
> NAME="SLES"
> VERSION="15-SP2"
> VERSION_ID="15.2"
> PRETTY_NAME="SUSE Linux Enterprise Server 15 SP2"
> ID="sles"
> ID_LIKE="suse"
> ANSI_COLOR="0;32"
> CPE_NAME="cpe:/o:suse:sles:15:sp2"
>
> # zypper in postgis30_11
> Refreshing service 'spacewalk'.
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides SFCGAL needed by
> postgis30_11-3.0.3-4.sles15.x86_64
>  Solution 1: do not install postgis30_11-3.0.3-4.sles15.x86_64
>  Solution 2: break postgis30_11-3.0.3-4.sles15.x86_64 by ignoring
> some of
> its dependencies
>
> Choose from above solutions by number or cancel [1/2/c/d/?] (c): 1
> Resolving dependencies...
> Resolving package dependencies...
> Nothing to do.
>
>
> # zypper in postgis30_12
> Refreshing service 'spacewalk'.
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides gmp needed by postgis30_12-3.0.3-
> 4.sles15.x86_64
>  Solution 1: do not install postgis30_12-3.0.3-4.sles15.x86_64
>  Solution 2: break postgis30_12-3.0.3-4.sles15.x86_64 by ignoring
> some of
> its dependencies
>
> Choose from above solutions by number or cancel [1/2/c/d/?] (c): 1
> Resolving dependencies...
> Resolving package dependencies...
> Nothing to do.
>
>
> # zypper in postgis30_13
> Refreshing service 'spacewalk'.
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides gmp needed by postgis30_13-3.0.3-
> 4.sles15.x86_64
>  Solution 1: do not install postgis30_13-3.0.3-4.sles15.x86_64
>  Solution 2: break postgis30_13-3.0.3-4.sles15.x86_64 by ignoring
> some of
> its dependencies
>
> Choose from above solutions by number or cancel [1/2/c/d/?] (c): 1
> Resolving dependencies...
> Resolving package dependencies...
> Nothing to do.
>
>
> # zypper in postgis31_11
> Refreshing service 'spacewalk'.
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides SFCGAL needed by
> postgis31_11-3.1.0-2.sles15.x86_64
>  Solution 1: do not install postgis31_11-3.1.0-2.sles15.x86_64
>  Solution 2: break postgis31_11-3.1.0-2.sles15.x86_64 by ignoring
> some of
> its dependencies
>
> Choose from above solutions by number or cancel [1/2/c/d/?] (c): 1
> Resolving dependencies...
> Resolving package dependencies...
> Nothing to do.
>
>
> # zypper in postgis31_12
> Refreshing service 'spacewalk'.
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides gmp needed by postgis31_12-3.1.0-
> 2.sles15.x86_64
>  Solution 1: do not install postgis31_12-3.1.0-2.sles15.x86_64
>  Solution 2: break postgis31_12-3.1.0-2.sles15.x86_64 by ignoring
> some of
> its dependencies
>
> Choose from above solutions by number or cancel [1/2/c/d/?] (c): 1
> Resolving dependencies...
> Resolving package dependencies...
> Nothing to do.
>
>
> # zypper in postgis31_13
>
> Loading repository data...
> Reading installed packages...
> Resolving package dependencies...
>
> Problem: nothing provides gmp needed by postgis31_13-3.1.0-
> 2.sles15.x86_64
>  Solution 1: do not install postgis31_13-3.1.0-2.sles15.x86_64
>  Solution 2: break postgis31_13-3.1.0-2.sles15.x86_64 by ignoring
> some of
> its dependencies
>
> Choose from above solutions by number or cancel [1/2/c/d/?] (c): 1
> Resolving dependencies...
> Resolving package dependencies...
> Nothing to do.
>
> Many thanks
> Kind regard
> Heiko Kaempf
>

--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR