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

Which of the following parameters must be set to enable logical replication in PostgreSQL?

work_mem

max_connections

wal_level

shared_buffers

None

The 'wal_level' parameter must be set to 'logical' to enable logical replication, which allows changes to be streamed to subscribers.

What is the effect of setting 'synchronous_commit' to 'remote_apply' in a synchronous replication setup?

Transactions are committed after being received by the standby server.

Transactions are committed immediately on the primary server.

Transactions are committed only after being applied on all synchronous standbys.

Transactions are committed after being written to the WAL on the primary.

None

Setting 'synchronous_commit' to 'remote_apply' ensures that transactions are committed only after they have been applied on all synchronous standbys, providing strong consistency.

Loading questions...

Click Submit to see your final score!

Start Quiz Next

Time's up

Scroll to Top