Ubuntu alert USN-6656-2 (postgresql-9.5)

From:
             
 
Allen Huang <allen.huang@canonical.com>
To:
             
 
ubuntu-security-announce@lists.ubuntu.com
Subject:
             
 
[USN-6656-2] PostgreSQL vulnerability
Date:
             
 
Tue, 12 Mar 2024 14:26:31 +0000
Message-ID:
             
 
<8e402fde-d12d-41df-9254-2107fdb489d8@canonical.com>
==========================================================================
Ubuntu Security Notice USN-6656-2
March 12, 2024

postgresql-9.5 vulnerability
==========================================================================

A security issue affects these releases of Ubuntu and its derivatives:

- Ubuntu 16.04 LTS (Available with Ubuntu Pro)

Summary:

PostgreSQL could be made to run arbitrary SQL.

Software Description:
- postgresql-9.5: Object-relational SQL database

Details:

USN-6656-1 fixed several vulnerabilities in PostgreSQL. This update provides
the corresponding updates for Ubuntu 16.04 LTS

Original advisory details:

  It was discovered that PostgreSQL incorrectly handled dropping privileges
  when handling REFRESH MATERIALIZED VIEW CONCURRENTLY commands. If a user or
  automatic system were tricked into running a specially crafted command, a
  remote attacker could possibly use this issue to execute arbitrary SQL
  functions.

Update instructions:

The problem can be corrected by updating your system to the following
package versions:

Ubuntu 16.04 LTS (Available with Ubuntu Pro):
   postgresql-9.5                  9.5.25-0ubuntu0.16.04.1+esm7
   postgresql-client-9.5           9.5.25-0ubuntu0.16.04.1+esm7

After a standard system update you need to restart PostgreSQL to make all
the necessary changes.

References:
   https://ubuntu.com/security/notices/USN-6656-2
   https://ubuntu.com/security/notices/USN-6656-1
   CVE-2024-0985