Skip to content

Instantly share code, notes, and snippets.

View ratnakri's full-sized avatar

Ratna Kristiawati ratnakri

View GitHub Profile
@ratnakri
ratnakri / pglogical
Created January 30, 2018 04:45
short tutorial to setup replication using pglogical
Edit /var/lib/postgres/data/postgresql.conf:
# change IP on subscriber
listen_addresses = '*'
wal_level = logical
shared_preload_libraries = 'pglogical'
max_worker_processes = 16
max_wal_senders = 16
max_replication_slots = 16
track_commit_timestamp = on