Setup postgres For Go

postgres.go

package db

import "github.com/jackc/pgx"

// InitPostgres func
func InitPostgres() (dbConnPool *pgx.ConnPool) {
	conf := getConfig()
	var err error

	pgxConf := &pgx.ConnConfig{
		Port:     uint16(conf.Port),
		Host:     conf.Host,
		User:     conf.User,
		Password: conf.Password,
		Database: conf.DbName,
	}

	if dbConnPool, err = pgx.NewConnPool(
		pgx.ConnPoolConfig{
			ConnConfig:     *pgxConf,
			MaxConnections: 5,
		},
	); err != nil {
		panic(err)
	}
	return
}