Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Drop replication slot

Remove a replication slot when it is no longer needed.

Back to sheetBrowse commands
Sign in to save
Section: Replication and WAL

Drop replication slot

sql
sql
SELECT pg_drop_replication_slot('standby_1');
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Replication and WAL
Create physical replication slot
Create a physical slot to retain WAL for a replica.
OpenIn sheetsqlsame section
Show wal_level
Inspect the current WAL level setting.
OpenIn sheetsqlsame section
Show max_wal_senders
Check capacity for replication sender processes.
OpenIn sheetsqlsame section
Current WAL LSN
Inspect the current write-ahead log position.
OpenIn sheetsqlsame section
Create logical publication
Publish table changes for logical replication.
OpenIn sheetsqlsame section
Create subscription
Subscribe to logical replication changes from another server.
OpenIn sheetsqlsame section