[BUG]: Soem events do not come to lago when there is slight increase in load

[Deathcall404]

We have a self hosted lago, but when we stream events, ( let's say more than 100 in 15s ). It doesn't show on loago dashboard in
developers events section.

Did some research on the issue,

It is an issue with postgres connection. I exposed sidekiq endpoint and checked dead messages.
The error message I saw was

ActiveRecord::ConnectionNotEstablished: connection to server at "xxx.xx.xx.xx", port 5432 failed: FATAL: remaining connection slots are reserved for roles with the SUPERUSER attribute

I will need a way to increase the number of max connection to the lago postgres db, is there any way I can do it through helm charts of lago.

[vincent-pochet]

Hello @Deathcall404,

Thank you for reporting this.

You can update the number of database connection on Lago's side by passing the DATABASE_POOL environment variable to the API and workers containers. You will have to check for the max number of connection that can be opened on Postgres side as well.

DATABASE_POOL appears to be missing in the documentation (https://doc.getlago.com/guide/self-hosted/docker), we will update it.