<div dir="ltr">Hi!<div><br></div><div>I have seen basicallythe same issues here, but currently my problem is a bit different.</div><div><br></div><div>Similar configuration (I guess):</div><div><br></div><div>5 clients, all running pgpool, no virtual IP, hosts use the local pool.</div>
<div>2 backends (actually 2 of the 5 clients, since backends run pgpool2 as well), streaming replication, online_recovery, pool config is streaming replication as well, with load balancing.</div><div><br></div><div>I still don't get the exact idea of how this should work. </div>
<div><br></div><div>Pools don't seem to share the status information:</div><div> - Stopping one of the backends removes the backend only on the pool hosts where there is open database link.</div><div>f.e.:</div><div>
<br>
</div><div><div>qa-openfire-1:</div><div> Node: 0</div><div> Host: qa-postgres-1</div><div> Port: 5433</div><div> Weight: 0.250000</div><div> Status: Up, in pool and connected (2)</div><div><br></div><div>
Node: 1</div>
<div> Host: qa-postgres-2</div><div> Port: 5433</div><div> Weight: 0.750000</div><div> Status: Up, detached from pool (3)</div><div>qa-postgres-1:</div><div> Node: 0</div><div> Host: qa-postgres-1</div>
<div>
Port: 5433</div><div> Weight: 0.250000</div><div> Status: Up, in pool (1)</div><div><br></div><div> Node: 1</div><div> Host: qa-postgres-2</div><div> Port: 5433</div><div> Weight: 0.750000</div><div>
Status: Up, in pool (1)</div></div><div><br></div><div>"postgres*" hosts are the backends, pool instance is almost always idle. I have restarted postgres-2 recently. Only those pool instalces detached the stopped server, where it was in Connected status. Is it OK this way?</div>
<div><br></div><div>If other_pgpool* and heartbeat_destination* are setup correctly, the nodes are supposed to share consistent status aren't they?</div><div><br></div><div>regards,</div><div> Attila</div></div>