Skip to content

Glossary: PostgreSQL Beyond the Basics

Logical replication

Also written: CREATE PUBLICATION, CREATE SUBSCRIPTION

Copying chosen tables as rows, using a publication on the source and a subscription on the target. It works between different major versions, which makes it a near-zero-downtime upgrade method.

Where the book teaches it

Related terms

Streaming replication