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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general