Hello,
i try to use pglogical with postgres 9.6
i have used this guide
https://github.com/2ndQuadrant/pglogical#replication-sets
provider:
cat /etc/postgresql/9.6/main/local.conf
# local postgres conf
listen_addresses = '*'
wal_level = 'logical'
max_worker_processes = 10 # one per database needed on provider node
# one per node needed on subscriber node
max_replication_slots = 100 # one per node needed on provider node
max_wal_senders = 10 # one per node needed on provider node
shared_preload_libraries = 'pglogical'
hg_hba.conf
local replication postgres peer
host replication postgres 127.0.0.1/32 md5
host replication postgres ::1/128 md5
hostssl all postgres subscriberip trust
hostssl replication postgres subscriberrip trust
subscriber:
cat /etc/postgresql/9.6/main/local.conf
# local postgres conf
listen_addresses = '*'
wal_level = 'logical'
max_worker_processes = 10 # one per database needed on provider node
# one per node needed on subscriber node
shared_preload_libraries = 'pglogical'
hg_hba.conf
# replication privilege.
local replication postgres peer
host replication postgres 127.0.0.1/32 md5
host replication postgres ::1/128 md5
hostssl kesys postgres subscriberip trust
hostssl replication postgres subscriberip trust
On subscriber the log always say
2017-08-31 14:19:49.260 CEST [16736] LOG: apply worker [16736] at slot
2 generation 32 crashed
2017-08-31 14:19:49.262 CEST [15884] LOG: Worker-Prozess: pglogical
apply 16627:1763399739 (PID 16736) beendete mit Status 1
2017-08-31 14:22:09.843 CEST [16765] LOG: starting apply for
subscription subscription1
2017-08-31 14:22:09.843 CEST [16765] FEHLER: subscriber subscription1
initialization failed during nonrecoverable step (d), please try the
setup again
2017-08-31 14:22:09.843 CEST [16765] LOG: apply worker [16765] at slot
2 generation 33 crashed
2017-08-31 14:22:09.844 CEST [15884] LOG: Worker-Prozess: pglogical
apply 12407:1763399739 (PID 16765) beendete mit Status 1
2017-08-31 14:22:49.308 CEST [16767] LOG: starting apply for
subscription subscription1
2017-08-31 14:22:49.308 CEST [16767] FEHLER: subscriber subscription1
initialization failed during nonrecoverable step (d), please try the
setup again
2017-08-31 14:22:49.308 CEST [16767] LOG: apply worker [16767] at slot
2 generation 34 crashed
2017-08-31 14:22:49.310 CEST [15884] LOG: Worker-Prozess: pglogical
apply 16627:1763399739 (PID 16767) beendete mit Status 1
I have retry< setup multipole times, always the same error.
What i have done wrong?
Best Regards,
basti