Try pglogical with postgres 9.6

From: basti <mailinglist(at)unix-solution(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Try pglogical with postgres 9.6
Date: 2017-08-31 12:24:44
Message-ID: f037799f-1e8c-f7b0-fc1e-1ce79c9e2cb8@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-08-31 12:29:19 Re: Table create time
Previous Message Condor 2017-08-31 11:45:11 Re: How to check streaming replication status