utils

Documentation

Overview

Package utils holds generic utils about postgres instances

Index

• func DBToFloat64(t interface{}) (float64, bool)
• func DBToString(t interface{}) (string, bool)
• func DBToUint64(t interface{}) (uint64, bool)
• func DisableSuperuserPassword(db *sql.DB) error
• func GetAllAccessibleDatabases(tx *sql.Tx, whereClause string) (databases []string, errors []error)
• func GetMajorVersion(pgData string) (int, error)
• func GetPgVersion(db *sql.DB) (*semver.Version, error)
• func SetUserPassword(username string, password string, db *sql.DB) error

Functions

func DBToFloat64

func DBToFloat64(t interface{}) (float64, bool)

DBToFloat64 convert a dynamic value to float64s for Prometheus consumption. Null types are mapped to NaN. string and []byte types are mapped as NaN and !ok

func DBToString

func DBToString(t interface{}) (string, bool)

DBToString convert a dynamic type to string for Prometheus labels. Null types are mapped to empty strings.

func DBToUint64

func DBToUint64(t interface{}) (uint64, bool)

DBToUint64 convert a dynamic type to uint64 for Prometheus consumption. Null types are mapped to 0. string and []byte types are mapped as 0 and !ok

func DisableSuperuserPassword

func DisableSuperuserPassword(db *sql.DB) error

DisableSuperuserPassword disables the password for the `postgres` user

func GetAllAccessibleDatabases

func GetAllAccessibleDatabases(tx *sql.Tx, whereClause string) (databases []string, errors []error)

GetAllAccessibleDatabases returns the list of all the accessible databases using the superuser

func GetMajorVersion

func GetMajorVersion(pgData string) (int, error)

GetMajorVersion read the PG_VERSION file in the data directory returning the major version of the database

func GetPgVersion

func GetPgVersion(db *sql.DB) (*semver.Version, error)

GetPgVersion returns the version of postgres in a semantic format or an error

func SetUserPassword

func SetUserPassword(username string, password string, db *sql.DB) error

SetUserPassword change the password of a user in the PostgreSQL database