An example of setting a connection timeout on pgx stdlib

pgxtimeout.go

package main

import (
	"database/sql"
	"log"
	"net"
	"time"

	"github.com/jackc/pgx"
	"github.com/jackc/pgx/stdlib"
)

func main() {
	timeOutDialer := net.Dialer{Timeout: 10 * time.Second}

	driverConfig := stdlib.DriverConfig{
		ConnConfig: pgx.ConnConfig{
			Dial: timeOutDialer.Dial,
		},
	}

	stdlib.RegisterDriverConfig(&driverConfig)

	// try to open a connection to a non-existant database
	db, err := sql.Open("pgx", driverConfig.ConnectionString("postgresql://postgres:postgres@192.168.192.192/test"))
	if err != nil {
		// it won't fail here, database/sql doesn't pull a connection until it needs it.
		log.Fatal(err)
	}

	// here is where it actually tries to connect and will timeout
	err = db.Ping()
	if err != nil {
		log.Fatal(err)
	}
}