Search Postgresql Archives

Try pglogical with postgres 9.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux