go

SSL is not enabled on the server

Trying to communicate with a postgres database with go, preparing the statement like this:

var stmt *sql.Stmt
var err error

stmt, err = db.Prepare(selectStatement)
if err != nil {
    fmt.Printf("db.Prepare error: %v\n",err)
    return err
}

Throws the following error:

db.Prepare error: pq: SSL is not enabled on the server

Any solution ?

I can add more information, if needed.

Solution

  • You should establish DB connection without SSL encryption, like that:

    db, err := sql.Open("postgres", "user=test password=test dbname=test sslmode=disable")