Cheat Sheet logoCheat Sheet Today
PostgreSQL Advanced Cheat Sheet/Create logical publication

Publish table changes for logical replication.

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

Create logical publication

sql
sql
CREATE PUBLICATION app_pub FOR TABLE public.users, public.orders;
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
Refresh subscription
Pull publication membership changes to the subscriber.
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