3 ms·
I think replication is the way to go, it’s kinda what it’s for. Might be a bit tricky to get debezium to decode the logical event, not sure
by williamdclt 1y ago
I think replication is the way to go, it’s kinda what it’s for.
Might be a bit tricky to get debezium to decode the logical event, not sure
- cyberax 1y agoSure, but the replication protocol requires a separate connection. And the annoying part is that it requires a separate `pg_hba.conf` entry to be allowed. So it's not enabled for IAM-based connections on AWS, for example. pg_logical_slot_get_binary_changes returns the same entries as the replication connection. It just has no support for long-polling.
- gunnarmorling 1y agoDebezium handles logical decoding messages OOTB. There's also an SMT (single message transform) for decoding the binary payload: https://debezium.io/documentation/reference/stable/transformations/decode-logical-decoding-message-content.html https://debezium.io/documentation/reference/stable/transform....