Re: Current postgis builds broken???

[Devrim Gündüz]

Hi,

On Fri, 2024-01-12 at 19:24 +, Scott Pasnikowski wrote:
> [rocky@sai-int-test-cortex-airflow-test4 singlenode]$ sudo dnf -y
> install postgis34_15
> Last metadata expiration check: 0:02:48 ago on Fri 12 Jan 2024
> 07:15:57 PM UTC.
> Error:
>  Problem: package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15
> requires gdal36-libs >= 3.6.3, but none of the providers can be
> installed
>   - package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires
> libgdal.so.32()(64bit), but none of the providers can be installed
>   - cannot install the best candidate for the job
>   - nothing provides libarmadillo.so.10()(64bit) needed by gdal36-
> libs-3.6.4-4PGDG.rhel8.x86_64 from pgdg-common
>   - nothing provides libarmadillo.so.10()(64bit) needed by gdal36-
> libs-3.6.4-5PGDG.rhel8.x86_64 from pgdg-common
> (try to add '--skip-broken' to skip uninstallable packages or '--
> nobest' to use not only best candidate packages)

Fixed in yesterday's releases. New gdal36 package version is 3.6.4-6.

Regards,
-- 
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR

Re: Current postgis builds broken???

[Scott Pasnikowski]

Verified - Joshua is correct.

Installing the armadillo package from archive as suggested now fixes Postgis 
install on Rocky.

S


On Jan 12, 2024, at 3:25 PM, Joshua Kacsir  
wrote:


You don't often get email from joshua.kac...@crunchydata.com. Learn why this is 
important
Good evening,

 Problem: package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires 
gdal36-libs >= 3.6.3, but none of the providers can be installed
  - package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires 
libgdal.so.32()(64bit), but none of the providers can be installed
  - cannot install the best candidate for the job
  - nothing provides libarmadillo.so.10()(64bit) needed by 
gdal36-libs-3.6.4-4PGDG.rhel8.x86_64 from pgdg-common
  - nothing provides libarmadillo.so.10()(64bit) needed by 
gdal36-libs-3.6.4-5PGDG.rhel8.x86_64 from pgdg-common
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use 
not only best candidate packages)

Apparently EPEL updated the armadillo package to version 12 without making it 
backwards compatible; the older package can be found here however:

https://dl.fedoraproject.org/pub/archive/epel/8.8/Everything/x86_64/Packages/a/

Best Regards,

--
Joshua Kacsir
Data Architect
www.crunchydata.com
joshua.kac...@crunchydata.com

[This email was written *without* the assistance of LLMs]

Re: Current postgis builds broken???

[Joshua Kacsir]

Good evening,


>  Problem: package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15
>> requires gdal36-libs >= 3.6.3, but none of the providers can be installed
>>   - package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires
>> libgdal.so.32()(64bit), but none of the providers can be installed
>>   - cannot install the best candidate for the job
>>   - nothing provides libarmadillo.so.10()(64bit) needed by
>> gdal36-libs-3.6.4-4PGDG.rhel8.x86_64 from pgdg-common
>>   - nothing provides libarmadillo.so.10()(64bit) needed by
>> gdal36-libs-3.6.4-5PGDG.rhel8.x86_64 from pgdg-common
>> (try to add '--skip-broken' to skip uninstallable packages or '--nobest'
>> to use not only best candidate packages)
>>
>
Apparently EPEL updated the armadillo package to version 12 without making
it backwards compatible; the older package can be found here however:

https://dl.fedoraproject.org/pub/archive/epel/8.8/Everything/x86_64/Packages/a/

Best Regards,

-- 
Joshua Kacsir
Data Architect
www.crunchydata.com
joshua.kac...@crunchydata.com

[This email was written *without* the assistance of LLMs]

Re: Current postgis builds broken???

[Devrim Gündüz]

Hi,

Sorry for the top posting.

Did you enable CRB repo as well? Instructions are here:

https://yum.postgresql.org/howto/

Regards, Devrim

On 12 January 2024 19:24:19 GMT, Scott Pasnikowski 
 wrote:
>
>Yesterday I was doing a fresh install of our server package and quickly 
>recieved error messages that postgis wont install...
>
>This appears to have happened late afternoon (PST).
>
>Does anyone know whats up?
>
>
>
>[rocky@sai-int-test-cortex-airflow-test4 singlenode]$ sudo dnf -y install 
>postgis34_15
>Last metadata expiration check: 0:02:48 ago on Fri 12 Jan 2024 07:15:57 PM UTC.
>Error:
> Problem: package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires 
> gdal36-libs >= 3.6.3, but none of the providers can be installed
>  - package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires 
> libgdal.so.32()(64bit), but none of the providers can be installed
>  - cannot install the best candidate for the job
>  - nothing provides libarmadillo.so.10()(64bit) needed by 
> gdal36-libs-3.6.4-4PGDG.rhel8.x86_64 from pgdg-common
>  - nothing provides libarmadillo.so.10()(64bit) needed by 
> gdal36-libs-3.6.4-5PGDG.rhel8.x86_64 from pgdg-common
>(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to 
>use not only best candidate packages)

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.

Re: Current postgis builds broken???

[Scott Pasnikowski]

Verified epel-release is installed.

Yesterday morning the same postgis install (ansible script) on a clean machine 
was successful.
Yesterday afternoon these postgis errors started


Maybe related to...
Postgres has revved their repo files...(as of Jan 2) I think they removed pg11 
entry and added a pg17dev entry.   I have had to update multiple pg machines 
because the simple repo update
invalidated the gpg signature of something I needed to download a new repo 
file and that fixes yum/dnf updates.

Wondering if this may have hit the postgis build farm... just a thought.

S



From: Regina Obe 
Sent: Friday, January 12, 2024 12:03 PM
To: Scott Pasnikowski ; 'PostGIS Users 
Discussion' 
Subject: RE: Current postgis builds broken???


Looks like you might be missing epel-release



Did you already do



dnf -y install epel-release





as detailed here - 
https://postgis.net/documentation/getting_started/install_red_hat/





You might get more answers on the 
https://www.postgresql.org/list/pgsql-pkg-yum/  mailing list.



Hope that helps,

Regina



From: Scott Pasnikowski 
Sent: Friday, January 12, 2024 2:24 PM
To: 'PostGIS Users Discussion' 
Subject: Current postgis builds broken???





Yesterday I was doing a fresh install of our server package and quickly 
recieved error messages that postgis wont install...



This appears to have happened late afternoon (PST).



Does anyone know whats up?







[rocky@sai-int-test-cortex-airflow-test4 singlenode]$ sudo dnf -y install 
postgis34_15

Last metadata expiration check: 0:02:48 ago on Fri 12 Jan 2024 07:15:57 PM UTC.

Error:

 Problem: package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires 
gdal36-libs >= 3.6.3, but none of the providers can be installed

  - package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires 
libgdal.so.32()(64bit), but none of the providers can be installed

  - cannot install the best candidate for the job

  - nothing provides libarmadillo.so.10()(64bit) needed by 
gdal36-libs-3.6.4-4PGDG.rhel8.x86_64 from pgdg-common

  - nothing provides libarmadillo.so.10()(64bit) needed by 
gdal36-libs-3.6.4-5PGDG.rhel8.x86_64 from pgdg-common

(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use 
not only best candidate packages)

RE: Current postgis builds broken???

[Regina Obe]

Looks like you might be missing epel-release

 

Did you already do 

 

dnf -y install epel-release

 

 

as detailed here -
https://postgis.net/documentation/getting_started/install_red_hat/

 

 

You might get more answers on the
https://www.postgresql.org/list/pgsql-pkg-yum/  mailing list.

 

Hope that helps,

Regina

 

From: Scott Pasnikowski  
Sent: Friday, January 12, 2024 2:24 PM
To: 'PostGIS Users Discussion' 
Subject: Current postgis builds broken???

 

 

Yesterday I was doing a fresh install of our server package and quickly
recieved error messages that postgis wont install...

 

This appears to have happened late afternoon (PST).

 

Does anyone know whats up?

 

 

 

[rocky@sai-int-test-cortex-airflow-test4 singlenode]$ sudo dnf -y install
postgis34_15

Last metadata expiration check: 0:02:48 ago on Fri 12 Jan 2024 07:15:57 PM
UTC.

Error:

 Problem: package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires
gdal36-libs >= 3.6.3, but none of the providers can be installed

  - package postgis34_15-3.4.1-1PGDG.rhel8.x86_64 from pgdg15 requires
libgdal.so.32()(64bit), but none of the providers can be installed

  - cannot install the best candidate for the job

  - nothing provides libarmadillo.so.10()(64bit) needed by
gdal36-libs-3.6.4-4PGDG.rhel8.x86_64 from pgdg-common

  - nothing provides libarmadillo.so.10()(64bit) needed by
gdal36-libs-3.6.4-5PGDG.rhel8.x86_64 from pgdg-common

(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to
use not only best candidate packages)