TMAegis
More rules for postgres

PostgreSQL

TMA-POSTGRES-1.2

Install only required packages

LowLevel 1Manual reviewpostgres

Description

Depending on the distribution, several other packages next to the mandatory postgresql might have been installed upon a system. Typical add-on packages are: ; postgresql-doc: PostgreSQL documentation. ; phppgadmin: PostgreSQL web-based administration tool. ; ...

How it is checked

Audit method: Manual review

This recommendation cannot be checked automatically. A scan lists it with these instructions when you pass --include-manual.

List installed PostgreSQL packages (rpm -qa | grep -i postgres or dpkg -l | grep -i postgres) and compare with apt search postgresql / dnf search postgresql. Only packages required for this server's role (server, client, needed contrib/extensions) should be installed; anything unneeded is a finding.

How it is fixed

Fix method: Guidance or infrastructure patch

Remove PostgreSQL packages and extensions not required for the server role with the OS package manager (dnf remove / apt remove).

Properties

Operating systems
Any
Tags
postgresdatabasepackagesmanual
Reference
CIS PostgreSQL 18 Benchmark v1.0.0 - 1.2 Install only required packages