Re: Explanantion on pgbouncer please

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