Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Refresh subscription

Pull publication membership changes to the subscriber.

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

Refresh subscription

sql
sql
ALTER SUBSCRIPTION app_sub REFRESH PUBLICATION;
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 subscription
Subscribe to logical replication changes from another server.
OpenIn sheetsqlsame section
Create logical publication
Publish table changes for logical replication.
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
Create physical replication slot
Create a physical slot to retain WAL for a replica.
OpenIn sheetsqlsame section
Drop replication slot
Remove a replication slot when it is no longer needed.
OpenIn sheetsqlsame section