Details
-
Task
-
Resolution: Unresolved
-
Major
-
None
-
None
-
False
-
None
-
False
Description
Snippet form conversation
Regarding PostgreSQL I would need to check the official PostgreSQL documentation for versions 13 and 14, but at least up to version 12, logical replication slots cannot be created on a replica of a PostgreSQL cluster.
I think this is a limitation of "streaming replication", and logical replication behaves differently.
To make sure, I made some simple test cases. It seems to work fine when I set up Debezium to PostgreSQL replica(subscriber of logical replication):
https://github.com/nobusue/practice-postgres-logical-replication/tree/cascade-replication