Bug 1216960 (CVE-2023-5870)

Summary:	VUL-0: CVE-2023-5870: postgresql,postgresql12,postgresql13,postgresql14,postgresql15,postgresql16: pg_signal sending signals to root processes
Product:	[Novell Products] SUSE Security Incidents	Reporter:	SMASH SMASH <smash_bz>
Component:	Incidents	Assignee:	Security Team bot <security-team>
Status:	RESOLVED FIXED	QA Contact:	Security Team bot <security-team>
Severity:	Normal
Priority:	P3 - Medium	CC:	max, meissner
Version:	unspecified
Target Milestone:	---
Hardware:	Other
OS:	Other
URL:	https://smash.suse.de/issue/384362/
Whiteboard:	CVSSv3.1:SUSE:CVE-2023-5870:6.2:(AV:L/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H)
Found By:	Security Response Team	Services Priority:
Business Priority:		Blocker:	---
Marketing QA Status:	---	IT Deployment:	---

Description SMASH SMASH 2023-11-08 13:30:33 UTC

Prevent the pg_signal_backend role from signalling background workers and autovacuum processes (Noah Misch, Jelte Fennema-Nio)

The documentation says that pg_signal_backend cannot issue signals to superuser-owned processes. It was able to signal these background  processes, though, because they advertise a role OID of zero. Treat that as indicating superuser ownership. The security implications of cancelling one of these process types are fairly small so far as the core code goes (we'll just start another one), but extensions might add background workers that are more vulnerable.

Also ensure that the is_superuser parameter is set correctly in such processes. No specific security consequences are known for that oversight,  but it might be significant for some extensions.

The PostgreSQL Project thanks Hemanth Sandrana and Mahendrakar Srinivasarao for reporting this problem. (CVE-2023-5870)

Comment 2 Maintenance Automation 2023-11-13 12:45:54 UTC

SUSE-SU-2023:4418-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql14-14.10-3.33.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql14-14.10-3.33.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql14-14.10-3.33.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql14-14.10-3.33.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 3 Maintenance Automation 2023-11-13 16:30:11 UTC

SUSE-SU-2023:4425-1: An update that solves three vulnerabilities, contains one feature and has six security fixes can now be installed.

Category: security (important)
Bug References: 1122892, 1179231, 1206796, 1209208, 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Jira References: PED-5586
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2
SUSE Linux Enterprise Server 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql16-16.1-3.7.1, postgresql-16-4.23.3, postgresql15-15.5-3.19.2

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 4 Maintenance Automation 2023-11-14 12:30:06 UTC

SUSE-SU-2023:4434-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql13-13.13-3.43.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql13-13.13-3.43.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql13-13.13-3.43.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql13-13.13-3.43.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 5 Maintenance Automation 2023-11-14 12:30:09 UTC

SUSE-SU-2023:4433-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
SUSE Linux Enterprise Software Development Kit 12 SP5 (src): postgresql12-12.17-3.49.1
SUSE Linux Enterprise High Performance Computing 12 SP5 (src): postgresql12-12.17-3.49.1
SUSE Linux Enterprise Server 12 SP5 (src): postgresql12-12.17-3.49.1
SUSE Linux Enterprise Server for SAP Applications 12 SP5 (src): postgresql12-12.17-3.49.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 6 Maintenance Automation 2023-11-16 08:30:03 UTC

SUSE-SU-2023:4455-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
openSUSE Leap 15.4 (src): postgresql13-13.13-150200.5.50.1
openSUSE Leap 15.5 (src): postgresql13-13.13-150200.5.50.1
Legacy Module 15-SP4 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql13-13.13-150200.5.50.1
Galera for Ericsson 15 SP5 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql13-13.13-150200.5.50.1
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql13-13.13-150200.5.50.1
SUSE Enterprise Storage 7.1 (src): postgresql13-13.13-150200.5.50.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 7 Maintenance Automation 2023-11-16 08:30:06 UTC

SUSE-SU-2023:4454-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
openSUSE Leap 15.4 (src): postgresql12-12.17-150200.8.54.1
openSUSE Leap 15.5 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql12-12.17-150200.8.54.1
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql12-12.17-150200.8.54.1
SUSE Enterprise Storage 7.1 (src): postgresql12-12.17-150200.8.54.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 8 Maintenance Automation 2023-11-20 12:30:07 UTC

SUSE-SU-2023:4479-1: An update that solves three vulnerabilities and has two security fixes can now be installed.

Category: security (important)
Bug References: 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Sources used:
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql14-14.10-150200.5.36.1
SUSE Enterprise Storage 7.1 (src): postgresql14-14.10-150200.5.36.1
openSUSE Leap 15.4 (src): postgresql14-14.10-150200.5.36.1
openSUSE Leap 15.5 (src): postgresql14-14.10-150200.5.36.1
Basesystem Module 15-SP4 (src): postgresql14-14.10-150200.5.36.1
Legacy Module 15-SP5 (src): postgresql14-14.10-150200.5.36.1
SUSE Package Hub 15 15-SP4 (src): postgresql14-14.10-150200.5.36.1
SUSE Package Hub 15 15-SP5 (src): postgresql14-14.10-150200.5.36.1
Server Applications Module 15-SP4 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql14-14.10-150200.5.36.1
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql14-14.10-150200.5.36.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 9 Maintenance Automation 2023-11-21 08:30:03 UTC

SUSE-SU-2023:4495-1: An update that solves three vulnerabilities, contains one feature and has six security fixes can now be installed.

Category: security (important)
Bug References: 1122892, 1179231, 1206796, 1209208, 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Jira References: PED-5586
Sources used:
openSUSE Leap 15.3 (src): postgresql-16-150300.10.18.3
openSUSE Leap 15.4 (src): postgresql-16-150400.4.9.2, postgresql16-mini-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
openSUSE Leap 15.5 (src): postgresql-16-150500.10.3.2, postgresql16-mini-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Basesystem Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Basesystem Module 15-SP5 (src): postgresql-16-150500.10.3.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Legacy Module 15-SP4 (src): postgresql-16-150400.4.9.2
Legacy Module 15-SP5 (src): postgresql-16-150500.10.3.2
SUSE Package Hub 15 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
SUSE Package Hub 15 15-SP5 (src): postgresql-16-150500.10.3.2, postgresql16-16.1-150200.5.7.1
Server Applications Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Server Applications Module 15-SP5 (src): postgresql-16-150500.10.3.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (src): postgresql16-16.1-150200.5.7.1, postgresql-16-150200.4.24.1
SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3
SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3
SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (src): postgresql16-16.1-150200.5.7.1, postgresql-16-150200.4.24.1
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3
SUSE Linux Enterprise Server for SAP Applications 15 SP2 (src): postgresql16-16.1-150200.5.7.1, postgresql-16-150200.4.24.1
SUSE Linux Enterprise Server for SAP Applications 15 SP3 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3
SUSE Enterprise Storage 7.1 (src): postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1, postgresql-16-150300.10.18.3

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 10 Maintenance Automation 2024-01-15 20:30:01 UTC

SUSE-SU-2024:0106-1: An update that solves three vulnerabilities, contains one feature and has six security fixes can now be installed.

Category: security (important)
Bug References: 1122892, 1179231, 1206796, 1209208, 1216022, 1216734, 1216960, 1216961, 1216962
CVE References: CVE-2023-5868, CVE-2023-5869, CVE-2023-5870
Jira References: PED-5586
Sources used:
Basesystem Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Basesystem Module 15-SP5 (src): postgresql16-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql-16-150500.10.3.2
Legacy Module 15-SP4 (src): postgresql-16-150400.4.9.2
Legacy Module 15-SP5 (src): postgresql-16-150500.10.3.2
SUSE Package Hub 15 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Server Applications Module 15-SP4 (src): postgresql-16-150400.4.9.2, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1
Server Applications Module 15-SP5 (src): postgresql16-16.1-150200.5.7.1, postgresql15-15.5-150200.5.19.1, postgresql-16-150500.10.3.2
SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (src): postgresql-16-150300.10.18.3, postgresql15-15.5-150200.5.19.1, postgresql16-16.1-150200.5.7.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.

Comment 11 OBSbugzilla Bot 2024-02-08 17:55:01 UTC

This is an autogenerated message for OBS integration:
This bug (1216960) was mentioned in
https://build.opensuse.org/request/show/1145273 Factory / postgresql12

Comment 12 Thomas Leroy 2024-07-05 15:30:25 UTC

All done, closing.

Comment 13 Thomas Leroy 2024-07-05 15:31:01 UTC

All done, closing.