On 10/31/2013 10:02 AM, si24 wrote:
> I don't know if this will help in terms of my problem?
>
> this came from the admin pgbouncer console.
>
>
> pgbouncer=# show pools;
> database | user | cl_active | cl_waiting | sv_active | sv_idle |
> sv_used| sv_tested | sv_login | maxwait
> -----------+-----------+-----------+------------+-----------+---------+---------+-----------+----------+---------
> pgbouncer | pgbouncer | 1 | 0 | 0 | 0 |
> 0| 0 | 0 | 0
> (1 row)
>
>
This looks wrong. There should be another pool listed for your actual
database. I don't think geoserver is hitting pgbouncer. You changed
the port number for the database connection in geoserver, right?
-Andy