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