[USN-6538-1] PostgreSQL vulnerabilities

-----BEGIN PGP SIGNATURE-----

iQIzBAEBCgAdFiEEUMSg3c8x5FLOsZtRZWnYVadEvpMFAmVwp8kACgkQZWnYVadE
vpPwBQ/+P//Tyt10Rd5+6PDVSxqwP34Je2+HZGaxbKhpHUEWJh2fuvkaUDTYWg2Y
UJD1Zm9qrkxIFcQykJ8OnkwaD+DyYZWgE/H8mUdmjadj1tL0UKzGu3WBak+UxuuD
Kp8lQ9BVSFxn4ckDwm/cKa0Sy6kzXT/L62BsIgvX8hoBqyNvrJLJANagU57iIw8q
e/QibUVM9RFF1MGQFn5eLnXiU8+OazT8MSB81Zi3PhQZ9U1ccuBF0sk0FQdS6sXK
QCrkWe0bqJ/hz9vtQ6uL5SBdE37otj11Q6wqsBXOrLhIUtcRAuKkPleUhAG4/Y1o
Ai27hMPojUDi4cXWEUoT+ylD/L3RpotIea3yR+YFpYrKc+qX6vG0xLLwVvtsljOt
1XTNi6lx6aiD69qkMXKrfq3XZKb1QrOZObJyV+NHedZwB6/lesCOSzN71m3Rx6Nm
GXsIJ6H4AobL9C+rbeUtqUfuTwBfplBgXyfJPJlq5974CMs4pWAd7ygkDUjOVVz5
KWup0UCWR998pP68r3zONzLDDHQySPFW7VF8K4V6xX3ukifqbwFtzATSRf+oQq3Y
UykSJpk3P0o51qd1H4lo+Kgw9K8jKGlyQtLl37PMtczu9IkswqnU9Sq9ZjSIfIb+
rOtvwyY/nJJakarnwwtkTr6pvg66QCoJfVamo2j4Mokp8TGk8Mg=
=BPhx
-----END PGP SIGNATURE-----
==========================================================================
Ubuntu Security Notice USN-6538-1
December 06, 2023

postgresql-12, postgresql-14, postgresql-15 vulnerabilities
==========================================================================

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

- Ubuntu 23.10
- Ubuntu 23.04
- Ubuntu 22.04 LTS
- Ubuntu 20.04 LTS

Summary:

Several security issues were fixed in PostgreSQL.

Software Description:
- postgresql-15: Object-relational SQL database
- postgresql-14: Object-relational SQL database
- postgresql-12: Object-relational SQL database

Details:

Jingzhou Fu discovered that PostgreSQL incorrectly handled certain unknown
arguments in aggregate function calls. A remote attacker could possibly use
this issue to obtain sensitive information. (CVE-2023-5868)

Pedro Gallegos discovered that PostgreSQL incorrectly handled modifying
certain SQL array values. A remote attacker could use this issue to obtain
sensitive information, or possibly execute arbitrary code. (CVE-2023-5869)

Hemanth Sandrana and Mahendrakar Srinivasarao discovered that PostgreSQL
allowed the pg_signal_backend role to signal certain superuser processes,
contrary to expectations. (CVE-2023-5870)

Update instructions:

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

Ubuntu 23.10:
postgresql-15 15.5-0ubuntu0.23.10.1
postgresql-client-15 15.5-0ubuntu0.23.10.1

Ubuntu 23.04:
postgresql-15 15.5-0ubuntu0.23.04.1
postgresql-client-15 15.5-0ubuntu0.23.04.1

Ubuntu 22.04 LTS:
postgresql-14 14.10-0ubuntu0.22.04.1
postgresql-client-14 14.10-0ubuntu0.22.04.1

Ubuntu 20.04 LTS:
postgresql-12 12.17-0ubuntu0.20.04.1
postgresql-client-12 12.17-0ubuntu0.20.04.1

This update uses a new upstream release, which includes additional bug
fixes. After a standard system update you need to restart PostgreSQL to
make all the necessary changes.

References:
https://ubuntu.com/security/notices/USN-6538-1
CVE-2023-5868, CVE-2023-5869, CVE-2023-5870

Package Information:
https://launchpad.net/ubuntu/+source/postgresql-15/15.5-0ubuntu0.23.10.1
https://launchpad.net/ubuntu/+source/postgresql-15/15.5-0ubuntu0.23.04.1
https://launchpad.net/ubuntu/+source/postgresql-14/14.10-0ubuntu0.22.04.1
https://launchpad.net/ubuntu/+source/postgresql-12/12.17-0ubuntu0.20.04.1