#1186·pq

SSPI Support

Author: KingDanxCreated Mar 28, 2025Updated Mar 17, 2026
Labelsnew-featurehelp-wanted

I'm seeking support for connecting to my postgres database via SSPI. I've spent hours trying to find a solution to work with my application and I'm hopeful I do not have to abandon the code and start over in another programing language with postgres SSPI authentication support.

pg_hba.conf example:

Image

My Go database connection example

go
psqlConnString := fmt.Sprintf("host=%s port=%d dbname='%s' sslmode=disable", d.host, d.port, d.dbname)
database, err := sql.Open("postgres", psqlConnString)
if err != nil {
  fmt.Println(err)
  return err
}

err = database.Ping()
if err != nil {
  return err
}

Returned error :

Error connecting to the database: pq: unknown authentication response: 9

Thank you for viewing my issue. If you need anymore information from me please let me know. Any support or suggestions will be greatly appreciated.