douhe3313 2019-08-28 16:48
浏览 635
已采纳

docker + golang lib / pq“拨号TCP 127.0.0.1:5432:连接:连接被拒绝”

sql.Open() wouldn't error:

if db, err = sql.Open("postgres", url); err != nil {
    return nil, fmt.Errorf("Postgres connect error : (%v)", err)
}

but db.Ping() would error:

if err = db.Ping(); err != nil {
    return nil, fmt.Errorf("Postgres ping error : (%v)", err)
}

and it was simply because the lib/pq connection string wouldn't connect from within a docker container with the seperated connection parameters.

For example:

url := fmt.Sprintf("user=%v password=%v host=%v port=%v dbname=%v",
    rs.conf.Redshift.User,
    rs.conf.Redshift.Password,
    rs.conf.Redshift.Host,
    rs.conf.Redshift.Port,
    rs.conf.Redshift.DB)
  • 写回答

1条回答 默认 最新

  • douzai8285 2019-08-28 16:48
    关注

    Using the connection string as a URL worked:

        url := fmt.Sprintf("postgres://%v:%v@%v:%v/%v?sslmode=disable",
            pql.conf.Postgres.User,
            pql.conf.Postgres.Password,
            pql.conf.Postgres.Host,
            pql.conf.Postgres.Port,
            pql.conf.Postgres.DB)
    

    See lib/pq docs here: https://godoc.org/github.com/lib/pq

    I was stuck on this for more than a day and I owe the fix to Nikolay Sandalov's comment here in GitHub: https://github.com/coreos/clair/issues/134#issuecomment-491300639

    Thank you, Nikolay

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 用python写一个多签情况下波场的代理资源和回收资源
  • ¥15 怎么在matlab中输出显示泵的流量-扬程和管路损失与流量均在一个表格里
  • ¥15 matlab学期例题代码答疑
  • ¥50 Hadoop:好友推荐
  • ¥15 在线手电筒追加按钮JS
  • ¥15 调用函数时,无关变量的改变引起函数值的改变
  • ¥15 xy坐标转化为经纬度坐标
  • ¥15 一般三角模糊数的上界值和下届值取中值的多少比较合理?
  • ¥15 cuda安装使用问题
  • ¥15 关于#python#的问题,请各位专家解答!