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

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

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

Transactions are committed immediately on the primary server.

Transactions are committed after being received by the standby server.

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.

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

max_connections

work_mem

shared_buffers

wal_level

None

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

Loading questions...

Click Submit to see your final score!

Start Quiz Next

Time's up

Scroll to Top