[OSGeo] #3246: Install pgbouncer on tracsvn

#3246: Install pgbouncer on tracsvn
----------------------+--------------------------------------
Reporter: robe | Owner: robe
     Type: task | Status: assigned
Priority: normal | Milestone: Sysadmin Contract 2024-I
Component: SysAdmin | Keywords:
----------------------+--------------------------------------
tracsvn as discussed in #3185 is running out of connections. To mitigate
we had increased the max connections in PostgreSQL and set a cap on each
trac instance. Every so often it still runs out of connections for
trac_osgeo and gitea.

Proposition I was thinking and strk was thinking as well is to install
pgbouncer. I have done that, and will detail my findings in comments
below
--
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/3246&gt;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3246: Install pgbouncer on tracsvn
----------------------+---------------------------------------
Reporter: robe | Owner: robe
     Type: task | Status: assigned
Priority: normal | Milestone: Sysadmin Contract 2024-I
Component: SysAdmin | Resolution:
Keywords: |
----------------------+---------------------------------------
Comment (by robe):

Okay I installed pgbouncer. The pgbouncer installed is kinda old, it is
what's currently available in buster 1.9.0.

I tried setting it up to pass trac_osgeo on it, but while it ran, it was
super slow.

I tried running for gitea, and it complains about gitea passing an
unsupported config extra_float_digits. Supposedly I can add this to the
ignore_startup_parameters list in pgbouncer.

But anyway I'm thinking might be better for me to wait on this until I
upgrade to bullseye, which will give us a new postgresql and newer version
of pgbouncer
--
Ticket URL: <#3246 (Install pgbouncer on tracsvn) – OSGeo;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.

#3246: Install pgbouncer on tracsvn
----------------------+---------------------------------------
Reporter: robe | Owner: robe
     Type: task | Status: assigned
Priority: normal | Milestone: Sysadmin Contract 2024-I
Component: SysAdmin | Resolution:
Keywords: |
----------------------+---------------------------------------
Comment (by strk):

bullseye upgrade is in staging on osgeo4-tracsvn-dev if you want to
experiment there
--
Ticket URL: <#3246 (Install pgbouncer on tracsvn) – OSGeo;
OSGeo <Gter - OSGeo;
OSGeo committee and general foundation issue tracker.