@Sir_Boops something got wedged with the DB connections running out again.

@samis X.x Might be a good idea to look into pgbouncer then!

@Sir_Boops does that deal with this one: 'could not obtain a connection from the pool within 5.000 seconds (waited 5.001 seconds); all pooled connections were in use'

@samis Yep! That's what it helps with :3

@Sir_Boops it's only happened very rarely so far, but I'll keep that in mind.

@Sir_Boops so I set this up two days ago. It happened again today. Do I need to adjust some pool settings or should I do something hacky like periodic restarts or setting the number really high?

@samis What's your
max_connections <- in postgresql
max_client_conn <- in pgbouncer
default_pool_size <- in pgbouncer

@Sir_Boops
max_connections = 100
max_client_conn = 100
default_pool_size = 20

@samis
Try setting
max_client_conn = 300
default_pool_size = 50
Both in pgbouncer ^^;

@Sir_Boops are those your settings

@samis Mine are 500,50 :p