Genie Discord forum

Author Avatarmichaelfliegner
10/24/2022, 6:39:12 PM

Hi!

How to recycle connections with SearchLight? I am running out of connections with a small number of calls. Postgres complains: error | LibPQ: connection to server at "127.0.0.1", port 5432 failed: FATAL: sorry, too many clients already connection to server at "127.0.0.1", port 5432 failed: FATAL: sorry, too many clients already

Author Avataressenciary
10/25/2022, 3:50:40 PM

is it a searchlight issue?

Author Avataressenciary
10/25/2022, 3:51:03 PM

looks like a postgres issue (number of connections available) and the fact that the connections don't disconnect?

Author Avataressenciary
10/25/2022, 3:52:01 PM

but anyway - there is a SearchLightPostgreSQL.CONNECTIONS collection

Author Avataressenciary
10/25/2022, 3:53:02 PM

if you have any suggestions on how to automate the reusal

Author Avataressenciary
10/25/2022, 3:53:17 PM

I guess we need more info about this issue

Author Avatarmichaelfliegner
10/25/2022, 3:53:22 PM

Just built disconnects into my app