Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Create physical replication slot

Create a physical slot to retain WAL for a replica.

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

Create physical replication slot

sql
sql
SELECT * FROM pg_create_physical_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
Drop replication slot
Remove a replication slot when it is no longer needed.
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