Postgres logical replication not working
we have created logical replication slot on pg 10 using below command
select * from pg_create_logical_replication_slot('slot', 'wal2json');
Above request creates slot on database
select * from pg_replication_slots;
PG replication not returning stream events using slot listen command.
Slots size automatically increases to high value.
Below are postgress level global configs
archive_mode=off archive_command=(disabled) ssl=off wal_level=logical shared_preload_libraries=decoderbufs, wal2json wal_keep_segments=100 max_replication_slots=100 max_wal_senders=30 wal_sender_timeout=0 max_standby_streaming_delay=-1
- What is best configuration for pg logical replication to fix our issue?
- Which is best plugin for logical replication our of below options:
- test decoding
Please provide inputs to fix our issue.