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. In a high-availability setup, what is the role of the 'hot_standby' parameter on a standby server? To enable read-only queries on the standby server. To allow the standby server to become the new primary automatically. To synchronize configuration files between primary and standby. To encrypt the data stream between primary and standby. None 1 out of 20 2. What is a key consideration when configuring 'synchronous_standby_names' in a PostgreSQL replication setup? The order of standby names affects which standby is chosen as the synchronous standby. All standby servers must be listed to ensure data consistency. It determines the maximum number of WAL files retained on the primary. It specifies the network bandwidth allocation for each standby. None 2 out of 20 Loading questions... 3 out of 20 Loading questions... 4 out of 20 Loading questions... 5 out of 20 Loading questions... 6 out of 20 Loading questions... 7 out of 20 Loading questions... 8 out of 20 Loading questions... 9 out of 20 Loading questions... 10 out of 20 Loading questions... 11 out of 20 Loading questions... 12 out of 20 Loading questions... 13 out of 20 Loading questions... 14 out of 20 Loading questions... 15 out of 20 Loading questions... 16 out of 20 Loading questions... 17 out of 20 Loading questions... 18 out of 20 Loading questions... 19 out of 20 Loading questions... 20 out of 20 Click Submit to see your final score! Previous Start Quiz Next Time's upTime is Up!