Connection utilisation for pglogical

From: Rory Campbell-Lange <rory(at)campbell-lange(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Connection utilisation for pglogical
Date: 2017-10-06 13:50:18
Message-ID: 20171006135018.vbzj2jas6vst7t2f@campbell-lange.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ahead of setting up a testing environment to tryout pglogical, I'm keen
to learn of the connection requirements for pglogical publisher and
subscribers.

Our use case is a cluster of (say) 200 databases, and we would like to
look into aggregating data from a certain table using a row filter hook
into a central database, possibly in a remote cluster, for further
processing.

Based on the docs at https://github.com/2ndQuadrant/pglogical, the
configuration parameters appear to be:

wal_level = 'logical'
max_worker_processes = 10 # one per database needed on provider node
# one per node needed on subscriber node
max_replication_slots = 10 # one per node needed on provider node
max_wal_senders = 10 # one per node needed on provider node
shared_preload_libraries = 'pglogical'

So presumably in my example I assume we need 200 max_worker_processes,
200 max_replication_slots and 200 max_wal_senders? Does this translate
into 200 actual database connections?

Thanks for any advice
Rory

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-10-06 14:03:22 Re: compiling postgres_fdw fails for 9.6.5
Previous Message Sandeep Gupta 2017-10-06 13:22:41 compiling postgres_fdw fails for 9.6.5