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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
