Files

112 lines
2.7 KiB
Go

package postgres
import (
"errors"
"strings"
"time"
"github.com/jackc/pgx/v5/pgxpool"
"mtusi-messenger/internal/config"
"mtusi-messenger/internal/platform/tlsconfig"
)
const (
defaultHost = "localhost"
defaultPort = 5432
defaultDatabase = "messenger"
defaultMaxConns = int32(10)
defaultMinConns = int32(1)
defaultMaxConnLifetime = time.Hour
defaultMaxConnIdleTime = 30 * time.Minute
defaultConnectTimeout = 5 * time.Second
defaultQueryTimeout = 5 * time.Second
)
func normalize(cfg config.Postgres) (config.Postgres, error) {
if cfg.Host == "" {
cfg.Host = defaultHost
}
if strings.ContainsAny(cfg.Host, "/, \t\r\n") {
return cfg, errors.New("postgres: host must be a single tcp hostname or ip address")
}
if cfg.Port == 0 {
cfg.Port = defaultPort
}
if cfg.Database == "" {
cfg.Database = defaultDatabase
}
if cfg.User == "" || cfg.Password == "" {
return cfg, errors.New("postgres: user and password are required")
}
if cfg.SSLMode == "" {
cfg.SSLMode = "verify-full"
}
if cfg.SSLMode != "verify-full" {
return cfg, errors.New("postgres: ssl_mode must be verify-full")
}
if cfg.MaxConns == 0 {
cfg.MaxConns = defaultMaxConns
}
if cfg.MinConns == 0 {
cfg.MinConns = defaultMinConns
}
if cfg.MaxConnLifetime == 0 {
cfg.MaxConnLifetime = defaultMaxConnLifetime
}
if cfg.MaxConnIdleTime == 0 {
cfg.MaxConnIdleTime = defaultMaxConnIdleTime
}
if cfg.ConnectTimeout == 0 {
cfg.ConnectTimeout = defaultConnectTimeout
}
if cfg.QueryTimeout == 0 {
cfg.QueryTimeout = defaultQueryTimeout
}
if cfg.MinConns > cfg.MaxConns {
return cfg, errors.New("postgres: min_conns must not exceed max_conns")
}
return cfg, nil
}
// PoolConfig is shared by application pools and operator migration connections.
// Every new connection verifies the hostname, current trust bundle and CRLs.
func PoolConfig(cfg config.Postgres) (*pgxpool.Config, error) {
cfg, err := normalize(cfg)
if err != nil {
return nil, err
}
return poolConfig(cfg)
}
func poolConfig(cfg config.Postgres) (*pgxpool.Config, error) {
clientTLS, err := tlsconfig.NewClientFromEnv(cfg.Host)
if err != nil {
return nil, err
}
poolCfg, err := pgxpool.ParseConfig(cfg.DSN())
if err != nil {
// pgx parse errors include the DSN, which contains a password.
return nil, errors.New("postgres: invalid connection configuration")
}
poolCfg.ConnConfig.TLSConfig = clientTLS
poolCfg.ConnConfig.Fallbacks = nil
poolCfg.MaxConns = cfg.MaxConns
poolCfg.MinConns = cfg.MinConns
poolCfg.MaxConnLifetime = cfg.MaxConnLifetime
poolCfg.MaxConnIdleTime = cfg.MaxConnIdleTime
poolCfg.ConnConfig.ConnectTimeout = cfg.ConnectTimeout
return poolCfg, nil
}