| From: | Torsten Förtsch <torsten(dot)foertsch(at)gmx(dot)net> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Pgbouncer |
| Date: | 2015-11-30 21:46:01 |
| Message-ID: | 565CC399.4050400@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2015-11-30 21:50:51 | Re: Pgbouncer |
| Previous Message | Adrian Klaver | 2015-11-30 21:38:09 | Re: (psql 9.4.5) ERROR: syntax error at or near "createuser" |