<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p><font face="Lato">Hello, <br>
</font></p>
<p>We have a slony cluster with 11 nodes, and 3 sets. All PostgreSQL
servers are still running a 9.2.x version. The upgrade of Slony is
part of the PostgreSQL nodes upgrades, as we have to run a more
recent version, so as to be able to insert PG 11 nodes in the
cluster.<br>
</p>
<p>The replication topology is as follow:<br>
</p>
<p>Set 1 :</p>
<p>1 --- 2<br>
\ --- 3 --- 4<br>
\ --- 5<br>
\ --- 6<br>
\ --- 7<br>
\ --- 8<br>
\ --- 9<br>
\ --- 10<br>
\ --- 11<br>
</p>
<p>Set 2:</p>
<p>11 --- 12<br>
\ --- 3 --- 4<br>
\ --- 5<br>
\ --- 6<br>
\ --- 7<br>
\ --- 8<br>
\ --- 9<br>
\ --- 1<br>
\ --- 2<br>
</p>
<p>Set 3:</p>
<p>1 --- 2<br>
\ --- 3 --- 11<br>
\ --- 12</p>
<p>All slon daemons run on node 3.</p>
<p>When running slony 2.1.3, we had at most 20 or 25 connections on
every database. Once we upgraded to slony 2.2.7, we ended up with
107 slony connections on every node.<br>
</p>
<p>Is it a normal behaviour? Is there a way to lower that number, as
not every node needs to contact every other node?</p>
<p>Best, </p>
<div class="moz-signature">-- <br>
<div>
<div><font color="#00aee6">Dr Stéphane Schildknecht</font></div>
<div>Contact régional PostgreSQL pour l'Europe francophone</div>
<div>+33 617 11 37 42</div>
<br>
</div>
</div>
</body>
</html>