<html><head><style>p{margin-top:0px;margin-bottom:0px;}</style></head><body><div style="font-size:10pt; font-family:Gulim, sans-serif;"><p>Hi</p><p> </p><p>I am testing Streaming replication with pgpool but I have problem.</p><p> </p><p>I am useing client_idle_limit in pgpool.conf.</p><p> </p><p>Suppose I set client_idle_limit to 60.</p><p> </p><p>And after sending Query1, if I do not send Query2 for 60 seconds, the connection will be disconnected.</p><p> </p><p>Sixty seconds after the connection is disconnected, if I send Query 2, pgpool makes a new connection, and instead of getting a response, it send out an error.</p><p> </p><p>Like this.</p><p> </p><p>test=> SELECT * FROM pg_stat_activity ORDER BY query_start ASC;</p><p> datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port |</p><p> backend_start | xact_start | query_start | state_change</p><p> | waiting | state | backend_xid | backend_xmin | query</p><p>-------+---------+-------+----------+---------+------------------+---------------+-----------------+-------------+---</p><p>----------------------------+------------------------------+------------------------------+--------------------------</p><p>-----+---------+--------+-------------+--------------+----------------------------------------------------------</p><p> 16384 | test | 55934 | 16385 | test | psql | 11.22.412.534 | | 55053 | 20</p><p>18-12-19 18:27:03.215835+09 | 2018-12-19 18:27:07.53777+09 | 2018-12-19 18:27:07.53777+09 | 2018-12-19 18:27:07.53779</p><p>2+09 | f | active | | 1473227 | SELECT * FROM pg_stat_activity ORDER BY query_start ASC;</p><p>(1 row)</p><p> </p><p>test=> SELECT * FROM pg_stat_activity ORDER BY query_start ASC;</p><p>ERROR: unable to read data</p><p>DETAIL: child connection forced to terminate due to client_idle_limit:60 is reached</p><p>server closed the connection unexpectedly</p><p> This probably means the server terminated abnormally</p><p> before or while processing the request.</p><p>The connection to the server was lost. Attempting reset: Succeeded.</p><p> </p><p>Instead of getting an error when the connection is disconnected, I want to get a response by connecting a new connection.</p><p> </p><p>I need your help on this part.</p><div><br></div></div></body></html><table style='display:none'><tr><td><img src="https://mail.naver.com/readReceipt/notify/?img=4sFnbrl%2F1Nb9MxCvFAmspxuZMxJ0FqJ0a6E9az3CaxvZaziSFqKZM43gMX%2B0MogwKVl5WLl5pNiC740ThoRmpXITWrmRprk5pBiCWuImpXITWrm5W4kd.gif" border="0"/></td></tr></table>