← Back to Crunchy Data Postgres 16 Security Technical Implementation Guide

V-261935

CAT II (Medium)

When updates are applied to the PostgreSQL software, any software components that have been replaced or made unnecessary must be removed.

Rule ID

SV-261935r1000810_rule

STIG

Crunchy Data Postgres 16 Security Technical Implementation Guide

Version

V1R2

CCIs

CCI-002617

Discussion

Previous versions of PostgreSQL components that are not removed from the information system after updates have been installed may be exploited by adversaries. Some DBMSs' installation tools may remove older versions of software automatically from the information system. In other cases, manual review and removal will be required. In planning installations and upgrades, organizations must include steps (automated, manual, or both) to identify and remove the outdated modules. A transition period may be necessary when both the old and the new software are required. This should be taken into account in the planning.

Check Content

To check software installed by packages, as the system administrator, run the following command:

$ sudo rpm -qa | grep postgres

If multiple versions of postgres are installed but are unused, this is a finding.

Fix Text

Use package managers (RPM or apt-get) for installing PostgreSQL. Unused software is removed when updated.