JohnL Comments - Answer Overflow

db.SetMaxOpenConns(25) // Maximum number of open connections to the database
    db.SetMaxIdleConns(25) // Maximum number of idle connections in the pool
    db.SetConnMaxLifetime(5 * 60)

db.SetMaxOpenConns(25) // Maximum number of open connections to the database
    db.SetMaxIdleConns(25) // Maximum number of idle connections in the pool
    db.SetConnMaxLifetime(5 * 60)

Do you think this is the solution? Or should have pooling alone fixed the problem?

22 replies

RRailway

•Created by JohnL on 10/24/2024 in #✋｜help

Database too many clients crashes

No, only one app

22 replies

RRailway

•Created by JohnL on 10/24/2024 in #✋｜help

Database too many clients crashes

I then use the global db object throughout code

22 replies

RRailway

•Created by JohnL on 10/24/2024 in #✋｜help

Database too many clients crashes

@Brody Wait, I'm actually not opening a new connection each time... I don't think. Becuase I open it once and then make it a global variable called db.

package main

import (
    "database/sql"
    //"os"
    "fmt"

    _ "github.com/lib/pq"
)

var db *sql.DB

func InitDB( /*dbname string, password string, host string, port string, user string*/ ) {

    var err error

    //    "dbname="+dbname+" user="+user+" password="+password+" host="+host+" port="+port+" sslmode=disable"

    db, err = sql.Open("postgres", "postgresql://postgres:[email protected]:47665/railway")

    if err != nil {
        fmt.Println("InitDB err")
        panic(err)
    } else {
        fmt.Println("Connected to DB")
    }

}

package main

import (
    "database/sql"
    //"os"
    "fmt"

    _ "github.com/lib/pq"
)

var db *sql.DB

func InitDB( /*dbname string, password string, host string, port string, user string*/ ) {

    var err error

    //    "dbname="+dbname+" user="+user+" password="+password+" host="+host+" port="+port+" sslmode=disable"

    db, err = sql.Open("postgres", "postgresql://postgres:[email protected]:47665/railway")

    if err != nil {
        fmt.Println("InitDB err")
        panic(err)
    } else {
        fmt.Println("Connected to DB")
    }

}