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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
