1.4 Ensure systemd Service Files Are Enabled

Information

Confirm, and correct if necessary, the PostgreSQL systemd service is enabled.
Rationale:
Enabling the systemd service on the OS ensures the database service is active when a change of state occurs as in the case of a system startup or reboot.

Solution

Irrespective of package source, PostgreSQL services can be identified because it typically includes the text string 'postgresql'. PGDG installs do not automatically register the service as a 'want' of the default systemd target. Multiple instances of PostgreSQL services often distinguish themselves using a version number.
$ whoami
root
$ systemctl enable postgresql-10
Created symlink from /etc/systemd/system/multi-user.target.wants/postgresql-10.service to /usr/lib/systemd/system/postgresql-10.service.
$ systemctl list-dependencies multi-user.target | grep -i postgres
* postgresql-10.service

See Also

https://workbench.cisecurity.org/files/2306

Item Details

Category: SYSTEM AND SERVICES ACQUISITION

References: 800-53|SA-8, CSCv6|18, CSCv7|18

Plugin: Unix

Control ID: 3688d7ba30ed4809109b361e1ea562eded5fcdbdbf4d9f2d802c61efde5aeb8a