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

Subscribe to logical replication changes from another server.

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

Create subscription

sql
sql
CREATE SUBSCRIPTION app_sub
CONNECTION 'host=primary-db port=5432 dbname=appdb user=replicator password=secret'
PUBLICATION app_pub;
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
Refresh subscription
Pull publication membership changes to the subscriber.
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