Re: AW: Linux Update Experience

On 5/28/20 7:36 AM, Zwettler Markus (OIZ) wrote:
>> -----Ursprüngliche Nachricht-----
>> Von: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
>> Gesendet: Donnerstag, 28. Mai 2020 16:15
>> An: Zwettler Markus (OIZ) <Markus(dot)Zwettler(at)zuerich(dot)ch>; PostgreSQL General
>> <pgsql-general(at)lists(dot)postgresql(dot)org>
>> Betreff: Re: Linux Update Experience
>>
>> On 5/28/20 12:59 AM, Zwettler Markus (OIZ) wrote:
>>> We are running PGDG Postgres 9.6 and 12 on RHEL7.
>>>
>>> Our Linux team does global Linux updates on a quarterly basis (yum update).
>>>
>>> We are hitting more and more update problems.
>>>
>>> Some troubles this time:
>>>
>>> + Postgis24 has been updated to Postgis30
>>>
>>> + Postgres 12.2 has been updated to Postgres 12.3 claiming missing
>>> requirements:
>>>
>>> Error: Package: postgresql12-devel-12.3-1PGDG.rhel7.x86_64
>>> (imx_product_3rd_party_postgresql_repository_postgresql12_rhel7_x86_64)
>>>
>>>            Requires: llvm-toolset-7-clang >= 4.0.1
>>>
>>> Question: How to you handle your Linux update cycles? Not updating anymore?
>>
>> See here:
>>
>> https://yum.postgresql.org/news-newreporpmsreleased.php
>>
>> And if you have community account:
>>
>> https://redmine.postgresql.org/issues/5483
>>
>> To contact the RPM packagers directly:
>>
>> https://yum.postgresql.org/contact.php
>>
>>>
>>> Thanks,
>>>
>>> Markus
>>>
>>
>>
>> --
>> Adrian Klaver
>> adrian(dot)klaver(at)aklaver(dot)com
> [Zwettler Markus (OIZ)]
>
>
>
> Hi Adrian,
>
> I'm not talking about this specific bug or its resolution.
>
> I want to talk about the Linux update problem in general.
>
> Anyone updating Linux might get such nerving dependency troubles. >
> How do you handle this situation? Updating more frequently? Updating less frequently? Not updating anymore?

If you are installing via packages and the package managers are doing
there job then there should not be an issue. The dependencies should be
taken care of. As to version changes, that depends on the software. For
instance Postgres 12.2 --> 12.3 is a minor/bug release so it should be
something you get. Not sure about the PostGIS upgrade, that probably
depends on what repo(s) you are using. The bottom line is if you ask
for upgrades/updates you are going to get them. This means keeping track
of what is happening with updates to your software. Now you can pin/lock
versions, search on pinning/locking packages. The downside to that is
missing important bug fixes. I would say not updating qualifies as a
foot gun.

>
> Cheers,
> Markus
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com