search

2ndQuadrant / pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.01k stars 153 forks source link

worker registration failed #7

Closed trourance closed 8 years ago

trourance commented 8 years ago

Hello,

I'm trying to setup pglogical with an initial synchronization of structure and data. Following the quick setup part of the documentation, the advice to configure max_worker_processes parameter is # one per node needed on subscriber node. I have two nodes on the subscriber side and max_worker_processes = 4, but I still get an error during initial replication: ERROR: worker registration failed, you might want to increase max_worker_processes setting LOG: pglogical supervisor exited with code 1 LOG: starting pglogical supervisor

PJMODOS commented 8 years ago

This can happen in situation when you have many database in one postgres instance but only replicate few of them, workaround is to increase the max_worker_processes as the message suggests.

trourance commented 8 years ago

Ok, but in that case, how can I know how many max_worker_processes I should set ? And does it affect max_replication_slots and max_wal_senders, too ?

PJMODOS commented 8 years ago

There is one worker needed for the main maintenance process, one per subscription, one per replicated database and during startup it can need one per any connectable database on top of that. It does not affect slots or wal senders.

trourance commented 8 years ago

Ok, I'm going to follow that rule. Thanks