Information
Streaming replication from a PRIMARY host transmits DDL, DML, passwords, and other potentially sensitive activities and data. These connections should be protected with Secure Sockets Layer (SSL).
Rationale:
Unencrypted transmissions could reveal sensitive information to unauthorized parties. Unauthenticated connections could enable man-in-the-middle attacks.
NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.
Solution
Review prior sections in this benchmark regarding SSL certificates, replication user, and WAL archiving.
Confirm the file recovery.conf is present on the STANDBY host and contains lines similar to the following:
standby_mode=on
primary_conninfo = 'user=replication_user password=mypassword host=mySrcHost port=5432 sslmode=require sslcompression=1'