<div dir="ltr">Dear guys!<div><br></div><div>Where to find the problem in the situation above?</div><div><br></div><div>No logs at all, for some reason pgpool stopped logging (usually it uses syslog).</div><div><br></div><div>
<div>root@postgres-1:/etc/pgpool2# pool status</div><div>Node: 0</div><div>Host: postgres-1</div><div>Port: 5433</div><div>Weight: 0.500000</div><div>Status: Up, in pool (1)</div><div>Role: Master</div><div><br></div><div>
Node: 1</div><div>Host: postgres-2</div><div>Port: 5433</div><div>Weight: 0.500000</div><div>Status: Up, in pool (1)</div><div>Role: Master</div></div><div><br></div><div><div>root@postgres-2:/etc/pgpool2# pool status</div>
<div>Node: 0</div><div>Host: postgres-2</div><div>Port: 5433</div><div>Weight: 0.500000</div><div>Status: Up, in pool and connected (2)</div><div>Role: Master</div><div><br></div><div>Node: 1</div><div>Host: postgres-1</div>
<div>Port: 5433</div><div>Weight: 0.500000</div><div>Status: Up, in pool and connected (2)</div><div>Role: Master</div></div><div><br></div><div>This isn't the first time, usually happens in a high load situation.</div>
<div><br></div><div>Attila</div></div>