Streaming Replication & Slot Management Quiz Home › PostgreSQL DBA › Streaming Replication & Slot Management 📡 Postgres Database Administration – Streaming Replication & Slot Management 20 questions · 15 min timer · Explanations included · Free 1. Which of the following is a potential risk when using logical replication slots in PostgreSQL? Excessive disk space usage due to unconsumed WAL files. Network congestion due to high replication traffic. Automatic failover to standby servers. Increased CPU usage on the primary server. None Show Hint Logical replication slots can lead to excessive disk usage if the consumer is slow or disconnected, as WAL files are retained until consumed. 2. What is the role of the 'primary_conninfo' parameter in a standby server's recovery configuration? To configure the standby server's network settings. To specify the connection string for the standby to connect to the primary. To set the replication slot name used by the standby. To define the WAL file location on the standby server. None Show Hint The 'primary_conninfo' parameter specifies the connection string that the standby server uses to connect to the primary server for streaming replication. Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Loading questions... Click Submit to see your final score! Previous Start Quiz Next Time's up
