Skip to content

Latest commit

 

History

History
28 lines (19 loc) · 737 Bytes

README.md

File metadata and controls

28 lines (19 loc) · 737 Bytes

pg-jdbc-logical-decoding

install wal2json decoding plugin

pg_hba.conf

  • local replication pg-jdbc-logical-decoding peer
  • host replication pg-jdbc-logical-decoding 127.0.0.1/32 md5
  • host replication pg-jdbc-logical-decoding ::1/128 md5

postgres.conf

  • wal_level = logical
  • max_wal_senders = 8
  • wal_keep_segments = 4
  • wal_sender_timeout = 60s
  • max_replication_slots = 4

create database, role, replication slot and table

  • ./database/setup.sh

This script assumes that there is a superuser 'pgsql'.