From: | cchee-ob <carter(dot)chee(at)objectbrains(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Trying to setup pglogical with no success |
Date: | 2016-04-13 22:16:00 |
Message-ID: | 1460585760205-5898571.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Here's what I have done to try to set up pglogical. What am I doing wrong?
2 nodes
provider - 10.241.0.10
subscriber - 10.241.0.12
svp2=# select version();
version
------------------------------------------------------------------------------------------
PostgreSQL 9.5.2 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.9.2-10)
4.9.2, 64-bit
(1 row)
svp2=# \dx
List of installed extensions
Name | Version | Schema | Description
-----------+---------+------------+--------------------------------
pglogical | 1.0.1 | pglogical | PostgreSQL Logical Replication
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(2 rows)
pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
local all postgres trust
local replication postgres trust
# TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 trust
host svp2 svc,tms,svcro 0.0.0.0/0 md5
host all all 10.241.0.10/32 trust
host replication postgres 10.241.0.10/32 trust
host all all 10.241.0.12/32 trust
host replication postgres 10.241.0.12/32 trust
postgresql.conf
# PGLOGICAL
shared_preload_libraries = 'pglogical'
max_worker_processes = 10
wal_level = 'logical'
max_wal_senders = 10
max_replication_slots = 10
track_commit_timestamp = on
PROVIDER
select pglogical.create_node(
node_name := 'provider1',
dsn := 'host=10.241.0.10 port=5432 dbname=svp2');
select pglogical.replication_set_add_all_tables('default', ARRAY['public']);
SUBSCRIBER
select pglogical.create_node(
node_name := 'subscriber1',
dsn := 'host=10.241.0.12 port=5432 dbname=svp2');
select pglogical.create_subscription(
subscription_name := 'subscription1’,
provider_dsn := 'host=10.241.0.10 port=5432 dbname=svp2');
I get this error repeats until I drop the subscription.
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=DEBUG: 00000: registering
background worker "pglogical apply 16384:1763399739"
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOCATION:
BackgroundWorkerStateChange, bgworker.c:347
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=DEBUG: 00000: starting background
worker process "pglogical apply 16384:1763399739"
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOCATION: do_start_bgworker,
postmaster.c:5479
t=2016-04-12 11:31:24 PDT d= h= p=7723 a=ERROR: XX000: subscriber
subscription1 initialization failed during nonrecoverable step (s), please
try the setup again
t=2016-04-12 11:31:24 PDT d= h= p=7723 a=LOCATION:
pglogical_sync_subscription, pglogical_sync.c:514
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOG: 00000: worker process:
pglogical apply 16384:1763399739 (PID 7723) exited with exit code 1
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOCATION: LogChildExit,
postmaster.c:3449
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=DEBUG: 00000: unregistering
background worker "pglogical apply 16384:1763399739"
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOCATION: ForgetBackgroundWorker,
bgworker.c:376
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=DEBUG: 00000: registering
background worker "pglogical apply 16384:1763399739"
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOCATION:
BackgroundWorkerStateChange, bgworker.c:347
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=DEBUG: 00000: starting background
worker process "pglogical apply 16384:1763399739"
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOCATION: do_start_bgworker,
postmaster.c:5479
t=2016-04-12 11:31:24 PDT d= h= p=7724 a=ERROR: XX000: subscriber
subscription1 initialization failed during nonrecoverable step (s), please
try the setup again
t=2016-04-12 11:31:24 PDT d= h= p=7724 a=LOCATION:
pglogical_sync_subscription, pglogical_sync.c:514
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOG: 00000: worker process:
pglogical apply 16384:1763399739 (PID 7724) exited with exit code 1
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOCATION: LogChildExit,
postmaster.c:3449
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=DEBUG: 00000: unregistering
background worker "pglogical apply 16384:1763399739"
t=2016-04-12 11:31:24 PDT d= h= p=30336 a=LOCATION: ForgetBackgroundWorker,
bgworker.c:376
--
View this message in context: http://postgresql.nabble.com/Trying-to-setup-pglogical-with-no-success-tp5898571.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | FarjadFarid(ChkNet) | 2016-04-13 22:22:06 | Re: I/O - Increase RAM |
Previous Message | Mike Sofen | 2016-04-13 21:39:51 | Re: I/O - Increase RAM |