PostgreSQL Logical replication Practical use case

When creating a slot, use the specified logical decoding output plugin See Chapter 49 This option has no effect if the slot already exists -s

WITH ; NOTICE: created replication slot mysub on publisher CREATE SUBSCRIPTION DETAIL: Key = already exists

replication slot PostgreSQL's logical decoding uses replication slots First, you configure the replication slot: If the publication already exists (either for all

replication slot already exists replication and streaming replication modes Jon SCHEWE at already setup a PostgreSQL streaming replication cluster If