Opened 3 months ago
Last modified 3 months ago
#3246 assigned task
Install pgbouncer on tracsvn
| Reported by: | robe | Owned by: | robe |
|---|---|---|---|
| Priority: | normal | Milestone: | Sysadmin Contract 2024-I |
| Component: | SysAdmin | Keywords: | |
| Cc: |
Description
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
Change History (2)
comment:1 by , 3 months ago
comment:2 by , 3 months ago
bullseye upgrade is in staging on osgeo4-tracsvn-dev if you want to experiment there
Note:
See TracTickets
for help on using tickets.
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