SUSE-RU-2024:3473-1: moderate: Recommended update for postgresql, postgresql-pgagent

27 Sep 2024

      # Recommended update for postgresql, postgresql-pgagent

Announcement ID: SUSE-RU-2024:3473-1  
Rating: moderate  
References:

  * bsc#1230423

Affected Products:

  * Legacy Module 15-SP5
  * openSUSE Leap 15.4
  * openSUSE Leap 15.5
  * openSUSE Leap 15.6
  * SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4
  * SUSE Linux Enterprise High Performance Computing 15 SP4
  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4
  * SUSE Linux Enterprise Server 15 SP4
  * SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4
  * SUSE Linux Enterprise Server 15 SP5
  * SUSE Linux Enterprise Server for SAP Applications 15 SP4
  * SUSE Linux Enterprise Server for SAP Applications 15 SP5
  * SUSE Manager Proxy 4.3
  * SUSE Manager Retail Branch Server 4.3
  * SUSE Manager Server 4.3

An update that has one fix can now be installed.

## Description:

This update for postgresq, postgresql-pgagentl fixes the following issues:

  * Relax the dependency of extensions on the server version from exact
    major.minor to greater or equal, after Tom Lane confirmed on the PostgreSQL
    packagers list that ABI stability is being taken care of between minor
    releases. (bsc#1230423)

postgresql-pgagent is rebuilt with updated requirements.

## Patch Instructions:

To install this SUSE update use the SUSE recommended installation methods like
YaST online_update or "zypper patch".  
Alternatively you can run the command listed for your product:

  * openSUSE Leap 15.4  
    zypper in -t patch SUSE-2024-3473=1

  * openSUSE Leap 15.5  
    zypper in -t patch openSUSE-SLE-15.5-2024-3473=1

  * openSUSE Leap 15.6  
    zypper in -t patch openSUSE-SLE-15.6-2024-3473=1

  * Legacy Module 15-SP5  
    zypper in -t patch SUSE-SLE-Module-Legacy-15-SP5-2024-3473=1

  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-ESPOS-2024-3473=1

  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP4-LTSS-2024-3473=1

  * SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4  
    zypper in -t patch SUSE-SLE-Product-SLED-15-SP4-LTSS-2024-3473=1

  * SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4  
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP4-LTSS-2024-3473=1

  * SUSE Linux Enterprise Server for SAP Applications 15 SP4  
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP4-2024-3473=1

  * SUSE Manager Proxy 4.3  
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Proxy-4.3-2024-3473=1

  * SUSE Manager Retail Branch Server 4.3  
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Retail-Branch-
Server-4.3-2024-3473=1

  * SUSE Manager Server 4.3  
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Server-4.3-2024-3473=1

## Package List:

  * openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64 i586)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql10-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql10-pgagent-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql12-pgagent-4.0.0-150400.17.2.1
    * postgresql12-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql12-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql10-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql13-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * openSUSE Leap 15.4 (noarch)
    * postgresql-llvmjit-16-150400.4.15.2
    * postgresql-server-16-150400.4.15.2
    * postgresql-test-16-150400.4.15.2
    * postgresql-plpython-16-150400.4.15.2
    * postgresql-pltcl-16-150400.4.15.2
    * postgresql-devel-16-150400.4.15.2
    * postgresql-server-devel-16-150400.4.15.2
    * postgresql-16-150400.4.15.2
    * postgresql-plperl-16-150400.4.15.2
    * postgresql-llvmjit-devel-16-150400.4.15.2
    * postgresql-contrib-16-150400.4.15.2
    * postgresql-docs-16-150400.4.15.2
  * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql10-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql10-pgagent-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql12-pgagent-4.0.0-150400.17.2.1
    * postgresql12-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql12-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql10-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql13-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * openSUSE Leap 15.6 (aarch64 ppc64le s390x x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql10-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql10-pgagent-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql12-pgagent-4.0.0-150400.17.2.1
    * postgresql12-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql12-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql10-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql13-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * Legacy Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (noarch)
    * postgresql-llvmjit-16-150400.4.15.2
    * postgresql-server-16-150400.4.15.2
    * postgresql-plpython-16-150400.4.15.2
    * postgresql-pltcl-16-150400.4.15.2
    * postgresql-devel-16-150400.4.15.2
    * postgresql-server-devel-16-150400.4.15.2
    * postgresql-16-150400.4.15.2
    * postgresql-plperl-16-150400.4.15.2
    * postgresql-llvmjit-devel-16-150400.4.15.2
    * postgresql-contrib-16-150400.4.15.2
    * postgresql-docs-16-150400.4.15.2
  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP4 (aarch64
    x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql13-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (noarch)
    * postgresql-llvmjit-16-150400.4.15.2
    * postgresql-server-16-150400.4.15.2
    * postgresql-plpython-16-150400.4.15.2
    * postgresql-pltcl-16-150400.4.15.2
    * postgresql-devel-16-150400.4.15.2
    * postgresql-server-devel-16-150400.4.15.2
    * postgresql-16-150400.4.15.2
    * postgresql-plperl-16-150400.4.15.2
    * postgresql-llvmjit-devel-16-150400.4.15.2
    * postgresql-contrib-16-150400.4.15.2
    * postgresql-docs-16-150400.4.15.2
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP4 (aarch64
    x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql13-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * SUSE Linux Enterprise Desktop 15 SP4 LTSS 15-SP4 (noarch)
    * postgresql-16-150400.4.15.2
  * SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (noarch)
    * postgresql-llvmjit-16-150400.4.15.2
    * postgresql-server-16-150400.4.15.2
    * postgresql-plpython-16-150400.4.15.2
    * postgresql-pltcl-16-150400.4.15.2
    * postgresql-devel-16-150400.4.15.2
    * postgresql-server-devel-16-150400.4.15.2
    * postgresql-16-150400.4.15.2
    * postgresql-plperl-16-150400.4.15.2
    * postgresql-llvmjit-devel-16-150400.4.15.2
    * postgresql-contrib-16-150400.4.15.2
    * postgresql-docs-16-150400.4.15.2
  * SUSE Linux Enterprise Server 15 SP4 LTSS 15-SP4 (aarch64 ppc64le s390x
    x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql13-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP4 (noarch)
    * postgresql-llvmjit-16-150400.4.15.2
    * postgresql-server-16-150400.4.15.2
    * postgresql-plpython-16-150400.4.15.2
    * postgresql-pltcl-16-150400.4.15.2
    * postgresql-devel-16-150400.4.15.2
    * postgresql-server-devel-16-150400.4.15.2
    * postgresql-16-150400.4.15.2
    * postgresql-plperl-16-150400.4.15.2
    * postgresql-llvmjit-devel-16-150400.4.15.2
    * postgresql-contrib-16-150400.4.15.2
    * postgresql-docs-16-150400.4.15.2
  * SUSE Linux Enterprise Server for SAP Applications 15 SP4 (ppc64le x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql13-pgagent-debugsource-4.0.0-150400.17.2.1
    * postgresql13-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * SUSE Manager Proxy 4.3 (noarch)
    * postgresql-server-16-150400.4.15.2
    * postgresql-plpython-16-150400.4.15.2
    * postgresql-pltcl-16-150400.4.15.2
    * postgresql-devel-16-150400.4.15.2
    * postgresql-server-devel-16-150400.4.15.2
    * postgresql-16-150400.4.15.2
    * postgresql-docs-16-150400.4.15.2
    * postgresql-contrib-16-150400.4.15.2
    * postgresql-plperl-16-150400.4.15.2
  * SUSE Manager Proxy 4.3 (x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * SUSE Manager Retail Branch Server 4.3 (noarch)
    * postgresql-server-16-150400.4.15.2
    * postgresql-plpython-16-150400.4.15.2
    * postgresql-pltcl-16-150400.4.15.2
    * postgresql-devel-16-150400.4.15.2
    * postgresql-server-devel-16-150400.4.15.2
    * postgresql-16-150400.4.15.2
    * postgresql-docs-16-150400.4.15.2
    * postgresql-contrib-16-150400.4.15.2
    * postgresql-plperl-16-150400.4.15.2
  * SUSE Manager Retail Branch Server 4.3 (x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1
  * SUSE Manager Server 4.3 (noarch)
    * postgresql-server-16-150400.4.15.2
    * postgresql-plpython-16-150400.4.15.2
    * postgresql-pltcl-16-150400.4.15.2
    * postgresql-devel-16-150400.4.15.2
    * postgresql-server-devel-16-150400.4.15.2
    * postgresql-16-150400.4.15.2
    * postgresql-docs-16-150400.4.15.2
    * postgresql-contrib-16-150400.4.15.2
    * postgresql-plperl-16-150400.4.15.2
  * SUSE Manager Server 4.3 (ppc64le s390x x86_64)
    * postgresql14-pgagent-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debuginfo-4.0.0-150400.17.2.1
    * postgresql14-pgagent-debugsource-4.0.0-150400.17.2.1

## References:

  * https://bugzilla.suse.com/show_bug.cgi?id=1230423

SUSE-RU-2024:3473-1: moderate: Recommended update for postgresql, postgresql-pgagent

OPENSUSE-UPDATES