CODEWITHSUNDEEP
postgresqllogical-replication
user1409708
user1409708

Reputation: 1053

Postgres Logical Replication: Replication slot, Subscriber and Publisher Creation Order Matters?

I got to a scenario where it says publication does not exist, although it does. I suspect what caused this is the order the scripts ran on publisher and subscriber servers.

Is it valid to create "Replication slot", subscriber and publisher at any order?

Upvotes: 1

Views: 1136

Answers (1)

Laurenz Albe
Laurenz Albe

Reputation: 247575

Creating the subscription will create the replication slot by default, but you can opt to create the slot beforehand.

You can create a subscription before you create the publication, but then you'd have to refresh the subscription with ALTER SUBSCRIPTION ... REFRESH PUBLICATION.

Upvotes: 1

Related Questions