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

In a PostgreSQL replication setup, what is the function of the 'pg_rewind' tool?

To create logical replication slots on the primary server.

To compress WAL files for efficient storage.

To monitor replication lag between primary and standby.

To synchronize a failed primary server with the current primary after failover.

None

The 'pg_rewind' tool is used to synchronize a failed primary server with the current primary after a failover, allowing it to rejoin the replication setup.

What is the recommended method to safely remove a replication slot in PostgreSQL?

Directly delete the slot using the 'DROP SLOT' command.

Ensure the slot is inactive and then use 'pg_drop_replication_slot'.

Restart the primary server and the slot will be removed automatically.

Use 'pg_terminate_backend' to kill the slot's process.

None

The recommended method is to ensure the slot is inactive and then use 'pg_drop_replication_slot' to safely remove it without risking data loss.

Loading questions...

Click Submit to see your final score!

Start Quiz Next

Time's up

Scroll to Top