Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a3WGv-00046N-2u for pgsql-general@arkaria.postgresql.org; Mon, 30 Nov 2015 21:46:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a3WGu-0003xD-FK for pgsql-general@arkaria.postgresql.org; Mon, 30 Nov 2015 21:46:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a3WGt-0003wi-Lh for pgsql-general@postgresql.org; Mon, 30 Nov 2015 21:46:07 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1a3WGq-0003cz-TG for pgsql-general@postgresql.org; Mon, 30 Nov 2015 21:46:07 +0000 Received: from durian.home ([109.193.76.37]) by mail.gmx.com (mrgmx001) with ESMTPSA (Nemesis) id 0LgHvY-1afw1m0EIW-00nfIp for ; Mon, 30 Nov 2015 22:46:02 +0100 To: PostgreSQL General From: =?UTF-8?Q?Torsten_F=c3=b6rtsch?= Subject: Pgbouncer X-Enigmail-Draft-Status: N1110 Message-ID: <565CC399.4050400@gmx.net> Date: Mon, 30 Nov 2015 22:46:01 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.3.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K0:0dpNqM1ZEPNnJKW+/R9axpJ8opFOd1EnoAq7cCXcO2Tm5d3WM0T g0/c8TQ5G2GQGJnmSIYkBzjA5qEXzPBM8XNN09M0EJSuFy5GHA8M1rqU39taST6kmRcjH6b ZeGB+ZAwzWXDlhf6WajricIdns8JLiW94Q5I4nKF26Et7KkuJVHPgJJOW45WbIu+0tm23PN xJ+a3QdqlNQaCtKAUdUyg== X-UI-Out-Filterresults: notjunk:1;V01:K0:GJ3KOlKpbE8=:5lV5WT2yROr6vdlWsjGTOk uLh0mCeby9lfFhaHT7M2gzJwOMJg9PJXkeCFTKvSmTaUooNuZhPLP1lG5Pgg9K3QuQskpsyz4 3zjC5+S0owZGX7THqM+pA6MQNlTUaZ+Gdx69Wizj2IKjeZRAyOg4gvzgPBpjIePdl83ZsDHnp JRDacSvcQ93P10ivPXZVKE9VsrJCGyrHPZcQV3pHspliRnQpqPzmLaYyK8oUMkJBWLBAgVEjU EiQbj5tDtUmfS5X/jW30oqbk81Neh+tzx72s4n7ToAwyjdDnjTxUvXIsbyllm7QHBSWQ1Ea8A DOzZG2hOhPpPv40ztV2uaf8r71wD5PAJqE4oOM7O6Cf9vp6YM3mCwtd6L5YiLKGK5lof9WNNW Ktdf38Au5YS3n+IJ0dhQExQPq2MgCJeBfpgxm6iNC4GyfXVq7EVJEkIBLW5MLHnoUIk+1YhaX j75AV5rnVM02SwVQal/JZ7sZhThwLsi99nLw8PyeSCN30tJvl5Fg/4tawYmdrsDwCyenEYboA uXtJGdFlMaigE30HpQwBlSgBtGwGRk2m2JGBHl5bH060KIDG6hMh9jTJc0t+tg/Hw42s3I4ij cbbAnHLP1OAGJLkCqoFKr564S21kqd+ZBtiOJuhwtre+L0+vFb+oshfgTi/9o0Dac0wYYZHw4 xQHqXOc7tTi8Vo+BayqHv0kyV6JT7zs0z5jb04AgqEIF4mR801OriLUZGCIy/dKbMcjKmDsZ+ +xnbmJupctXJ5iIvE4WFpVLxPgJmQeYZLjxaF0ftzUbAFqNRRbmYo7hJpgUYNdPNDnOMbjGjr kboQG9m X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org Hi, I am not sure if this is the right place to ask this question. If not, please point me to it. I am trying out the new pgbouncer (latest git). "SHOW SERVERS" is telling me 2 connections in "active" state. Both show connect_time=2015-11-30 18:58:30. Request_time is 19:01:35 and 20:56:36. Both use pool_mode=transaction. Server_lifetime=600. And now is 21:38:55. Shouldn't those connections have been closed long ago? I also checked on the backend. The backend processes are there, are idle and query_start and state_change times match the request_times above. Also, since pool_mode=transaction, why are these connections "active"? Thanks, Torsten -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general