SUSE-SU-2024:0523-1: Security update for postgresql12

Published Feb 16, 2024
·
Updated

This update for postgresql12 fixes the following issues: Upgrade to 12.18: CVE-2024-0985: Tighten security restrictions within REFRESH MATERIALIZED VIEW CONCURRENTLY (bsc#1219679).

Affected Software

164 affected componentsFixes available
All of the following
SUSE openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
Any of the following
suse/postgresql12-plperl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-llvmjit-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-llvmjit-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debugsource<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-contrib<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-contrib-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-test<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-llvmjit<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE openSUSE Leap 15.5 (noarch)
suse/postgresql12-docs<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (aarch64 x86_64)
Any of the following
suse/postgresql12-contrib<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-contrib-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debugsource<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (noarch)
suse/postgresql12-docs<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64 x86_64)
Any of the following
suse/postgresql12-contrib<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-contrib-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debugsource<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (noarch)
suse/postgresql12-docs<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (aarch64 ppc64le s390x x86_64)
Any of the following
suse/postgresql12-contrib<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-contrib-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debugsource<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (noarch)
suse/postgresql12-docs<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (aarch64 ppc64le s390x x86_64)
Any of the following
suse/postgresql12-contrib<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-contrib-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debugsource<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (noarch)
suse/postgresql12-docs<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise Server for SAP Applications 15 SP2 (ppc64le x86_64)
Any of the following
suse/postgresql12-contrib<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-contrib-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debugsource<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise Server for SAP Applications 15 SP2 (noarch)
suse/postgresql12-docs<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64)
Any of the following
suse/postgresql12-contrib<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-contrib-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debugsource<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Linux Enterprise Server for SAP Applications 15 SP3 (noarch)
suse/postgresql12-docs<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Enterprise Storage 7.1 (aarch64 x86_64)
Any of the following
suse/postgresql12-contrib<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-contrib-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-pltcl-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plperl<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debugsource<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-devel<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-plpython<12.18-150200.8.57.1
12.18-150200.8.57.1
suse/postgresql12-server-debuginfo<12.18-150200.8.57.1
12.18-150200.8.57.1
All of the following
SUSE SUSE Enterprise Storage 7.1 (noarch)
suse/postgresql12-docs<12.18-150200.8.57.1
12.18-150200.8.57.1

Remediation

Recommended actions to resolve this vulnerability, in priority order.

  1. Upgrade

    Upgrade suse/postgresql12-plperl-debuginfo to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  2. Upgrade

    Upgrade suse/postgresql12-llvmjit-devel to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  3. Upgrade

    Upgrade suse/postgresql12-devel to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  4. Upgrade

    Upgrade suse/postgresql12-llvmjit-debuginfo to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  5. Upgrade

    Upgrade suse/postgresql12-plpython to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  6. Upgrade

    Upgrade suse/postgresql12-plperl to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  7. Upgrade

    Upgrade suse/postgresql12-debuginfo to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  8. Upgrade

    Upgrade suse/postgresql12-devel-debuginfo to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  9. Upgrade

    Upgrade suse/postgresql12-pltcl to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  10. Upgrade

    Upgrade suse/postgresql12-pltcl-debuginfo to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  11. Upgrade

    Upgrade suse/postgresql12 to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  12. Upgrade

    Upgrade suse/postgresql12-debugsource to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  13. Upgrade

    Upgrade suse/postgresql12-plpython-debuginfo to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  14. Upgrade

    Upgrade suse/postgresql12-contrib to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  15. Upgrade

    Upgrade suse/postgresql12-contrib-debuginfo to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  16. Upgrade

    Upgrade suse/postgresql12-test to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  17. Upgrade

    Upgrade suse/postgresql12-server-devel-debuginfo to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  18. Upgrade

    Upgrade suse/postgresql12-server to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  19. Upgrade

    Upgrade suse/postgresql12-server-devel to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  20. Upgrade

    Upgrade suse/postgresql12-llvmjit to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  21. Upgrade

    Upgrade suse/postgresql12-server-debuginfo to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  22. Upgrade

    Upgrade suse/postgresql12-docs to a version that resolves this vulnerability.

    Fixed in 12.18-150200.8.57.1
  23. Upgrade

    Upgrade postgresql12 to a version that resolves this vulnerability.

    Fixed in 12.18

Event History

Feb 16, 2024
Advisory Published
via SUSE·04:30 PM

Child vulnerabilities

Contains the following vulnerabilities.

Company

Resources

Contact

SecAlerts Pty Ltd.
132 Wickham Terrace
Fortitude Valley,
QLD 4006, Australia
info@secalerts.co
By using SecAlerts services, you agree to our services end-user license agreement. This website is safeguarded by reCAPTCHA and governed by the Google Privacy Policy and Terms of Service. All names, logos, and brands of products are owned by their respective owners, and any usage of these names, logos, and brands for identification purposes only does not imply endorsement. If you possess any content that requires removal, please get in touch with us.
© 2026 SecAlerts Pty Ltd.
ABN: 70 645 966 203, ACN: 645 966 203