pgc

Documentation

Index

• func Connect(config Config) (*sql.DB, error)
• func CreateDatabase(db *sql.DB, dbName, owner string) error
• func CreateUser(db *sql.DB, username, password string) error
• func GrantPrivileges(db *sql.DB, dbName, username, privileges string) error
• func RestartPostgres(command string) error
• func UpdatePgHba(pgHbaConf []struct{ ... }, pgHbaConfPath string) error
• type Config
  • func LoadConfig(filename string) (Config, error)

Functions

func Connect

func Connect(config Config) (*sql.DB, error)

func CreateDatabase

func CreateDatabase(db *sql.DB, dbName, owner string) error

func CreateUser

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

func GrantPrivileges

func GrantPrivileges(db *sql.DB, dbName, username, privileges string) error

func RestartPostgres

func RestartPostgres(command string) error

func UpdatePgHba

func UpdatePgHba(pgHbaConf []struct {
	Type     string `yaml:"type"`
	Database string `yaml:"database"`
	User     string `yaml:"user"`
	Address  string `yaml:"address"`
	Method   string `yaml:"method"`
}, pgHbaConfPath string) error

Types

type Config

type Config struct {
	Postgresql struct {
		Host     string `yaml:"host"`
		Port     int    `yaml:"port"`
		User     string `yaml:"user"`
		Password string `yaml:"password"`
	} `yaml:"postgresql"`
	Databases []struct {
		Name  string `yaml:"name"`
		Owner string `yaml:"owner"`
	} `yaml:"databases"`
	Users []struct {
		Name     string `yaml:"name"`
		Password string `yaml:"password"`
	} `yaml:"users"`
	Privileges []struct {
		Database   string `yaml:"database"`
		User       string `yaml:"user"`
		Privileges string `yaml:"privileges"`
	} `yaml:"privileges"`
	PgHba []struct {
		Type     string `yaml:"type"`
		Database string `yaml:"database"`
		User     string `yaml:"user"`
		Address  string `yaml:"address"`
		Method   string `yaml:"method"`
	} `yaml:"pg_hba"`
	PgHbaConfPath  string `yaml:"pg_hba_conf_path"`
	RestartCommand string `yaml:"restart_cmd"`
}

func LoadConfig

func LoadConfig(filename string) (Config, error)

Load the config from a file