Postgres number of connection

loancarre · February 8, 2018, 9:22am

hello,
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 ?

daniellee · February 14, 2018, 6:27pm

It should be setting the max open connections to 10:

github.com

grafana/grafana/blob/master/pkg/tsdb/sql_engine.go#L64


			e.XormEngine = engine
			return nil
		}
	}


	engine, err := xorm.NewEngine(driverName, cnnstr)
	if err != nil {
		return err
	}


	engine.SetMaxOpenConns(10)
	engine.SetMaxIdleConns(10)


	engineCache.cache[dsInfo.Id] = engine
	e.XormEngine = engine


	return nil
}


// Query is a default implementation of the Query method for an SQL data source.
// The caller of this function must implement transformToTimeSeries and transformToTable and

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).