golang database/sql using pq

Question

I'm having this issue

 db, err := sql.Open("postgres", "user=xxx dbname=xxx connect_timeout=5 sslmode=disable")
 if err != nil {
    log.Fatal(err)
 }

I have no postgres installed on my localhost so sql.Open should return some error but actually it is not until I try to prepare a query and finally I get a connection refused error

stmt, err := c.DB.Prepare("SELECT id FROM services WHERE name = $1")
if err != nil {
    log.Fatal(err)
}

is this an expected behaviour? or I'm missing something...

Yes, see related question: How do I handle opening/closing Db connection in a Go app? — icza
– icza, Commented Nov 15, 2016 at 10:30

sadlil · Accepted Answer · 2016-11-15 10:29:09Z

3

According to this, Yes it is an expected behavior. Open() does not directly open a connection to the database. Instead the first connection is opened when the database is actually used the first time.

Open may just validate its arguments without creating a connection 
to the database. 
To verify that the data source name is valid, call Ping.

Use Ping() to check if the connection is valid or not.

answered Nov 15, 2016 at 10:29

sadlil

3,1935 gold badges25 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gavello Over a year ago

thanks sadil I should read the documentation with more patience!

Collectives™ on Stack Overflow

golang database/sql using pq

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related