Ensure streaming replication parameters are configured correctly

OrtaDüzey 1Manuel incelemepostgres

Açıklama

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).

Nasıl denetlenir

Denetim yöntemi: Manuel inceleme

Bu öneri otomatik olarak denetlenemez. --include-manual parametresini verdiğinizde tarama bunu bu talimatlarla birlikte listeler.

Confirm a dedicated non-superuser replication role exists (SELECT rolname FROM pg_roles WHERE rolreplication;) and, from the standby, that psql 'host=<primary> dbname=postgres user=replication_user sslmode=require' -c 'select 1;' succeeds; check primary_conninfo on the standby uses sslmode=require or stronger.

Nasıl düzeltilir

Düzeltme yöntemi: Kılavuz veya altyapı yaması

On the standby set primary_conninfo = 'host=<primary> user=replication_user sslmode=verify-full ...' (and primary_slot_name), create standby.signal, and allow only hostssl replication entries on the primary.

Özellikler

İşletim sistemleri: Herhangi biri
Etiketler: postgresdatabasereplicationtlsmanual
Referans: CIS PostgreSQL 18 Benchmark v1.0.0 - 7.5 Ensure streaming replication parameters are configured correctly