Recommended update for postgresql

Announcement ID: SUSE-RU-2023:0062-1
Rating: moderate
References:
Affected Products:
  • SUSE Enterprise Storage 7
  • SUSE Linux Enterprise High Performance Computing 15 SP2
  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2
  • SUSE Linux Enterprise Server 15 SP2
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
  • SUSE Manager Proxy 4.1
  • SUSE Manager Retail Branch Server 4.1
  • SUSE Manager Server 4.1

An update that has one fix can now be installed.

Description:

This update for postgresql fixes the following issues:

  • revert to old postgresql user creation method, as sysusers on suse linux enterprise 15 sp3 and older does not support shell specification. bsc#1206796

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:

  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP2-LTSS-2023-62=1
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP2-LTSS-2023-62=1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP2-2023-62=1
  • SUSE Manager Proxy 4.1
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Proxy-4.1-2023-62=1
  • SUSE Manager Retail Branch Server 4.1
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Retail-Branch-Server-4.1-2023-62=1
  • SUSE Manager Server 4.1
    zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Server-4.1-2023-62=1
  • SUSE Enterprise Storage 7
    zypper in -t patch SUSE-Storage-7-2023-62=1

Package List:

  • SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (noarch)
    • postgresql-pltcl-15-150200.4.21.1
    • postgresql-plpython-15-150200.4.21.1
    • postgresql-server-devel-15-150200.4.21.1
    • postgresql-server-15-150200.4.21.1
    • postgresql-devel-15-150200.4.21.1
    • postgresql-15-150200.4.21.1
    • postgresql-contrib-15-150200.4.21.1
    • postgresql-plperl-15-150200.4.21.1
    • postgresql-docs-15-150200.4.21.1
  • SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (noarch)
    • postgresql-pltcl-15-150200.4.21.1
    • postgresql-plpython-15-150200.4.21.1
    • postgresql-server-devel-15-150200.4.21.1
    • postgresql-server-15-150200.4.21.1
    • postgresql-devel-15-150200.4.21.1
    • postgresql-15-150200.4.21.1
    • postgresql-contrib-15-150200.4.21.1
    • postgresql-plperl-15-150200.4.21.1
    • postgresql-docs-15-150200.4.21.1
  • SUSE Linux Enterprise Server for SAP Applications 15 SP2 (noarch)
    • postgresql-pltcl-15-150200.4.21.1
    • postgresql-plpython-15-150200.4.21.1
    • postgresql-server-devel-15-150200.4.21.1
    • postgresql-server-15-150200.4.21.1
    • postgresql-devel-15-150200.4.21.1
    • postgresql-15-150200.4.21.1
    • postgresql-contrib-15-150200.4.21.1
    • postgresql-plperl-15-150200.4.21.1
    • postgresql-docs-15-150200.4.21.1
  • SUSE Manager Proxy 4.1 (noarch)
    • postgresql-pltcl-15-150200.4.21.1
    • postgresql-plpython-15-150200.4.21.1
    • postgresql-server-devel-15-150200.4.21.1
    • postgresql-server-15-150200.4.21.1
    • postgresql-devel-15-150200.4.21.1
    • postgresql-15-150200.4.21.1
    • postgresql-contrib-15-150200.4.21.1
    • postgresql-plperl-15-150200.4.21.1
    • postgresql-docs-15-150200.4.21.1
  • SUSE Manager Retail Branch Server 4.1 (noarch)
    • postgresql-pltcl-15-150200.4.21.1
    • postgresql-plpython-15-150200.4.21.1
    • postgresql-server-devel-15-150200.4.21.1
    • postgresql-server-15-150200.4.21.1
    • postgresql-devel-15-150200.4.21.1
    • postgresql-15-150200.4.21.1
    • postgresql-contrib-15-150200.4.21.1
    • postgresql-plperl-15-150200.4.21.1
    • postgresql-docs-15-150200.4.21.1
  • SUSE Manager Server 4.1 (noarch)
    • postgresql-pltcl-15-150200.4.21.1
    • postgresql-plpython-15-150200.4.21.1
    • postgresql-server-devel-15-150200.4.21.1
    • postgresql-server-15-150200.4.21.1
    • postgresql-devel-15-150200.4.21.1
    • postgresql-15-150200.4.21.1
    • postgresql-contrib-15-150200.4.21.1
    • postgresql-plperl-15-150200.4.21.1
    • postgresql-docs-15-150200.4.21.1
  • SUSE Enterprise Storage 7 (noarch)
    • postgresql-pltcl-15-150200.4.21.1
    • postgresql-plpython-15-150200.4.21.1
    • postgresql-server-devel-15-150200.4.21.1
    • postgresql-server-15-150200.4.21.1
    • postgresql-devel-15-150200.4.21.1
    • postgresql-15-150200.4.21.1
    • postgresql-contrib-15-150200.4.21.1
    • postgresql-plperl-15-150200.4.21.1
    • postgresql-docs-15-150200.4.21.1

References: