7.4 Ensure WAL archiving is configured and functional - archive_command

Warning! Audit Deprecated

This audit has been deprecated and will be removed in a future update.

View Next Audit Version

Information

Write Ahead Log (WAL) Archiving, or Log Shipping, is the process of sending transaction log files from the PRIMARY host either to one or more STANDBY hosts or to be archived on a remote storage device for later use, e.g. PITR. There are several utilities that can copy WALs including, but not limited to, cp, scp, sftp, and rynsc. Basically, the server follows a set of runtime parameters which define when the WAL should be copied using one of the aforementioned utilities.

Rationale:

Unless the server has been correctly configured, one runs the risk of sending WALs in an unsecured, unencrypted fashion.

Solution

Change parameters and restart the server as required.

See Also

https://workbench.cisecurity.org/benchmarks/11866

Item Details

References: CSCv7|14.4

Plugin: PostgreSQLDB

Control ID: 99944a03cc3cf2bc82c5b3e61bdd0dc909fac9a360725dd7d11c5c7d589e207f