max connections limit lib/pq

[Tieson Molly]

I am running into an issue I have seen mentioned on here years ago. I am seeking the current best solution.

I have a web server connecting to a postgresql database using the standard database/sql and the lib/pq driver. I keep running out of connections over time as it seems the pool grows up to 100.

Is there a way to prevent or fix this?

Best regards,

Ty

[Tamás Gulácsi]

You have to carefully close every Rows, Stmt, Tx and Conn acquired by database/sql.

[Franco Marchesini]

If you really have over 100 simultaneous connection you need to configure postgresql engine

Regards

Franco

[gerald...@gmail.com]

what you want is to set SetMaxOpenConns, SetMaxIdleConns:

db, err := sql.Open(config.DriverName, GetDataSourceFromConfig(config))

if err != nil {

log.Fatal(err)

}

db.SetMaxOpenConns(config.MaxOpenConns)

db.SetMaxIdleConns(config.MaxIdleConns)

[Franco Marchesini]

Postgres default max connection is set to 100.

https://www.postgresql.org/docs/9.5/static/runtime-config-connection.html

max_connections (integer)

Determines the maximum number of concurrent connections to the database server. The default is typically 100 connections, but might be less if your kernel settings will not support it (as determined during initdb). This parameter can only be set at server start.

When running a standby server, you must set this parameter to the same or higher value than on the master server. Otherwise, queries will not be allowed in the standby server.