Advanced PostgreSQL: Indexing, Partitioning, Replication · Lesson

Configuring Publications

Learn to define publications on a master server to specify which tables and operations to replicate.

What are Publications?

Welcome! In PostgreSQL logical replication, a publication is like a channel on the master server that broadcasts data changes.

It defines what data (which tables) and which operations (INSERTs, UPDATEs, DELETEs, TRUNCATEs) should be replicated to subscribing servers.

Think of it as setting up a TV station: you decide which shows to broadcast and when.

Creating a publication is straightforward using the CREATE PUBLICATION command. Let's start with the simplest form.

This creates a publication that doesn't publish any tables yet, but it's ready to be configured.

CREATE PUBLICATION my_first_pub;