i am new in the use of grafana, i use a postgres datasource to create arround 30 graph in a dashboard but sometimes when the page is loading grafana tell me that the connection limit has been reached.
Furthermore when i look the postgres’s status i see that 1 graphic open 1 connection.
So what can i do to limit the postgres sql connection ?
It should be setting the max open connections to 10:
I suppose we could add that as a configuration option if it is causing problems. But that it is causing errors seems strange, 10 should be enough. Is it a Grafana problem with not enough open connections or is it your Postgres db that it getting overloaded?
Can you show the actual error and the max connections setting for your Postgres db (in postgresql.conf).